For each salesperson, list the total number of orders by month for the year 2010. (If you
Question:
For each salesperson, list the total number of orders by month for the year 2010. (If you are using Access, use the Month function. If you are using Oracle, convert the date to a string, using the TO_CHAR function, with the format string ‘Mon’ [i.e., TO_CHAR(order_date,‘MON’)]. If you are using another DBMS, you will need to investigate how to deal with months for this query.)
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Essentials of Database Management
ISBN: 978-0133405682
1st edition
Authors: Jeffrey A. Hoffer, Heikki Topi, Ramesh Venkataraman
Question Posted: