Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started