list sales by year

5 pts.
Tags:
Oracle
SQL
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following