$(10$pts$)$ Write one query that returns in one table the following information

from the tables above:

Order number, Customer Name, Grade, Date of Order, purchase amount,

Salesman, and commission. The output table should look like this the table

below. Please use Inner Joins and remember to rename the columns.

What does this query returns?

a$.$

$(5pts)$ SELECT $salesma{n}_{i}d,$ AVG$(purc{h}_{a}mt)$

FROM orders

WHERE $or{d}_d$ate $=\text{'}2012-09-10\text{'}$

GROUP $BYsalesma{n}_{i}d$;

b$.(5pts)$

SELECT ord$\_$no$,$ cust$\_$name, commission,

FROM salesman,orders, customer

WHERE orders.customer$\_$id $=$ customer.customer$\_$id

AND customer.grade IS NOT NULL;