list sales by year
You are to generate a set of sales reports using the tables above.
1) Build a rpeort of sales by year (you can use order total colum)
2) Expand this to include the employee name of the sales rep so
now you will show sales by rep by year
3) Also get the sale reps job descriptio and see what type of jobs
do sales rep have
4) Instead of total order value switch to the number of orders per
by sales rep year
5) Inseead of number of orders get the quatity of products sold by
sales reps by year
6) How did you handle null sales rep ID's... what do you think is
appropriate
Software/Hardware used:
Software/Hardware used:
ASKED:
March 27, 2008 6:31 PM
UPDATED:
March 28, 2008 5:19 PM
Answer Wiki:
Sorry, Kkd777, that's a homework assignment question, and it would be inappropriate for us just to hand you the answer. If you show what you have tried, and it doesn't work correctly, then we can offer suggestions as to why. Otherwise we cannot just do your homework for you. Besides, you forgot to copy/paste the table descriptions
We can also give hints. You will need SUM(orders.totalamount), and you will need to extract the year from the orders.dateordered column and use it in both the SELECT and the GROUP BY.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
