Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

11) Within the Orders schema, Display OrderID and CustomerID for any orders that have an estimated shipping date that occurred in the year of 2021.

11) Within the Orders schema, Display OrderID and CustomerID for any orders that have an estimated shipping date that occurred in the year of 2021.

12) Within the Orders schema, Display OrderID and CustomerID for any orders that have an actual shipping date that occurred in the month of October, but did not occur in the Year of 2020

13) Within the PRODUCT schema, list the item with the greatest (highest) price.

14) Within the Orders schema, using only the ProductSelection table, display the three Orders that have the greatest (highest) prices, grouped by OrderID

15) Within the Orders schema, count the total number of products that have been purchased on all orders - Do not group orders

16) Within the Orders schema, count the number of orders placed by each customer. - The number of items per order is irrelevant - You do not require the use of a JOIN or Subquery

17) Within the PRODUCT schema, show the product information for any product that has a review rating between 3 and 5 with a product category name of either Perishable or Miscellaneous. - You must utilize one, or more, subqueries for your response - You cannot use a JOIN anywhere within your query

18) Within the PRODUCT and Orders schema, show orders that include any products that were packaged in a gift box - You must utilize one, or more, subqueries for your response - You cannot use a JOIN anywhere within your query

19) Within the ORDERS and PRODUCT schema, show any order [OrderID] and Customer [CustomerID] where there is a single item which has a weight greater than 1 kilogram. - Evaluate the weight of each item independently, not the combined weight

20) Within the ORDERS and PRODUCT schemas, for each Customer Order, display the OrderID, CustomerID, ProductID and the Description for each of the products

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

Concepts Of Database Management

Authors: Joy L. Starks, Philip J. Pratt, Mary Z. Last

9th Edition

1337093424, 978-1337093422

More Books

Students also viewed these Databases questions