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  book-img-for-question

Essentials of Database Management

ISBN: 978-0133405682

1st edition

Authors: Jeffrey A. Hoffer, Heikki Topi, Ramesh Venkataraman

Question Posted: