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 F

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

1 Expert Approved Answer
Step: 1 Unlock

ORDERS Orderdate ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (2 attachments)

PDF file Icon

1803_60b8c1211fd3a_715965.pdf

180 KBs PDF File

Word file Icon

1803_60b8c1211fd3a_715965.docx

120 KBs Word File

Students Have Also Explored These Related Oracle 12c SQL Questions!