Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. List all the different product categories and sub categories in alphabetical order, list only the product category and product subcategory. Sort by the product

image text in transcribed
image text in transcribed
1. List all the different product categories and sub categories in alphabetical order, list only the product category and product subcategory. Sort by the product subcategory. 2. How many ORDERS had a CRITICAL order_priority? [Hint: you will use the function COUNT(*) ] 3. Display the order date and the ship date for all orders that were made April 1 through April 15. List the order date, ship date, order priority, and ship mode. Order the results by order_date. Do you notice anything unusual about the data? (Hint: You will need to join the orders and shipping together and use a join statement. You will need to limit the result set by the date field order_date

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting, 1, (6 Months)

Authors: Carl S. Warren, James M. Reeve, Jonathan Duchac

14th Edition

1337270814, 9781337270816

More Books

Students also viewed these Accounting questions