Question: List customer ID, customer name, order ID, order date, product ID and the quantity of each product ordered, for all customers who have placed orders.

  1. List customer ID, customer name, order ID, order date, product ID and the quantity of each product ordered, for all customers who have placed orders. Hint: You need to include 3 tables in your FROM clause and you will need 2 JOINS.
  2. List customer ID, customer name, order ID, order date, product name, quantity ordered, and price of each product, for all customers who have placed orders. Hint: You need to include 4 tables in your FROM clause and you will need 3 JOINS.
  3. List the customer name, city, and state of customers who ordered products 3 or 4. Hint: You need to include 3 tables in your FROM clause and you will need 2 JOINS.
  4. List the customer name, order date, and product description for those customers who have purchased a Computer Desk. Hint: You need to include 4 tables in your FROM clause and you will need 3 JOINs.
  5. Which products were ordered before 10/22/2008? List the product name, the quantity ordered, and the order date for all orders placed before 10/22/2008. Hint: Remember to use # sign as a delimiter for the date (order_date < #10/22/2008#).
  6. Write a query that will list the customer_name for orders that were placed before 10/22/2008.

Please give the queries which will work. The queries I received not working. Please check those and then provide the right solution.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Relationship between Processor and Display Quality Yes theres a relationship between the processor and the display quality of a device The processors capability affects how smoothly graphics are rende... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!