Question: If management needed to determine which book category generated the most sales in April 2009, which tables and fields would they consult to derive this
If management needed to determine which book category generated the most sales in April 2009, which tables and fields would they consult to derive this information?
Figure 1-5:

ORDERS Order# Customer# Orderdate Shipdate Shipstreet Shipcity Shipstate Shipzip Shipcost CUSTOMERS Customer# Lastname Firstname Email Address City State Zip Referred Region BOOKAUTHOR AUTHOR BOOKS AuthorID ISBN ISBN AuthorID Lname ORDERITEMS Title Pubdate PubID Fname Order# Item# Cost Retail ISBN Quantity Paideach Discount PUBLISHER Category PubID Name PROMOTION Contact Phone Gift Minretail Maxretail
Step by Step Solution
3.48 Rating (174 Votes )
There are 3 Steps involved in it
ORDERS Orderdate ... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (2 attachments)
1803_60b8c1211fd3a_715965.pdf
180 KBs PDF File
1803_60b8c1211fd3a_715965.docx
120 KBs Word File
