Show orders that include any products

Assignment Help Computer Engineering

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

Reference no: EM133368722

Questions Cloud

Texas black codes : In the Texas Black Codes, why would African Americans be required to sign yearly labor contracts but not the whites?

How will the arab spring=as force for democracy : In hindsight, and in your opinion, how will the "Arab Spring" be viewed? As a force for democracy?

Determine whether a behavioral trait is an adaptation : Describe the difference between proximate and ultimate explanations of behavior. Use human infant crying as an example.

Explains different metrics that are typically monitored : Explains different metrics that are typically monitored for MySQL databases Includes quantitative and qualitative analysis in your explanation

Show orders that include any products : CSCI 202 Harvard University Within the Orders schema, count the number of orders placed by each customer. - The number of items per order is irrelevant

Difference between tumor suppressors and oncogences : What is the difference between tumor suppressors and oncogenes? Describe how mutations affect each type of protein, and name specific examples.

What is the delta of the power call option : What is the delta of the power call option? What is the risk neutral probability of up movement? What is the value of the power option?

Counter insurgency in american revolution : Given the history of insurgency and counter insurgency in the American Revolution why is it a topic that as a society Americans are generally ignorant of?

Explain a simple elevator control algorithm in this context : CSE 1000 Broward College Explain a simple Elevator Control algorithm in this context- how priority inversion or solution are applied.

User Account

All Pages