List customer ID, customer name, order ID, order date, product ID and the quantity of each product
Fantastic news! We've Found the answer you've been seeking!
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. Hint: You need to include 3 tables in your FROM clause and you will need 2 JOINS.
- 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.
- 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.
- 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.
- 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#).
- 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.
Related Book For
Core Concepts Of Accounting Information Systems
ISBN: 9780470507025
11th Edition
Authors: Nancy A. Bagranoff, Mark G. Simkin, Carolyn Strand Norman
Posted Date: