$1.$a$.$ List the average sales amount quota for employees at AdventureWorks. Use AVG. $(2$ points$)$

$587202\mathrm{.}4539$

Assignment$10.$sql

$$ Assignmer

$--1.$b$.$ List the average sales amount quota for employees at AdventureWorks for $2008.(2$ points$)$

$541470\mathrm{.}5882$

$--1.$c$.$ List the name, title, and hire date for AdventureWorks employees whose sales quota for $2008$ is higher than the average for all employees for $2008.$

Be sure to use an appropriate sort. $(4$ points$)$

$16$ Rows

Hint $-$ Might want to use WHERE clause Twice!!! Once for inner query and once for outer query.

USE UNCorrelated Subquery

$2.$a$.$ List the average LIST PRICE of a bike sold by AdventureWorks. $(1$ point$)$

$1$ row

$--2.$b$.$ List all products in the Bikes category that have a list price higher than the average list price of a bike.

Show product alternate key, product name,

$$

and list price in the results set. Order the information so it is easy to understand. $(4$ points$)$

$50$ rows

UnCorrelated subquery

$--3.$a$.$ Find the average yearly income all customers in the customer table. $(2$ points$)$

$57,305\mathrm{.}7779$

$--3.$b$.$ Find all males in the customers table with an income less than or the same as the average

income of all customers. List last name, a comma and space, and first name in one column and yearly income. $(4$ points$)$

$4404$ rows

$--$

UnCorrelated subquery