Reference no: EM133368722
Question 1) Within the Orders schema, Display OrderID and CustomerID for any orders that have an estimated shipping date that occurred in the year of 2021.
Question 2) 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
Question 3) Within the PRODUCT schema, list the item with the greatest (highest) price.
Question 4) Within the Orders schema, using only the ProductSelection table, display the three Orders that have the greatest (highest) prices, grouped by OrderID
Question 5) Within the Orders schema, count the total number of products that have been purchased on all orders - Do not group orders
Question 6) 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
Question 7) 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
Question 8) 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
Question 9) 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
Question 10) Within the ORDERS and PRODUCT schemas, for each Customer Order, display the OrderID, CustomerID, ProductID and the Description for each of the products