SQL Query: 1.Find the product id and product description for the product with the highest product standard price. 2.Find
Posted: Sun Jul 10, 2022 11:25 am
SQL Query:
1.Find the product id and product description for the productwith the highest product standard price.
2.Find how many units of each product have beenordered. Result should be a 2 column table
3.Find the dollar amount of sales for each product. Onyour result, disvplay product description, product standard price,total order quantity per product and sales. Resultshould be 4 column table
4. Find any product which comes in more than onefinishes (assume that any product is offered in at most twodifferent finishes). The result should be a three column table withproduct description, and BOTH finishes listed on the same line. Aproduct should appear only once in the result.Resultshould be 3 column table
5. What product id, product description, product finishhave some sort of ‘Ash’ finish? Result should be 3column table
6. List the customers (customer id and customer name)who live in California or Washington. Result shouldbe 2 column table
7. Determine the average standard price of each productfinish (display product finish and averageprice). Result should be 2 column table
8. For every product that has been ordered, determinethe total quantity that has been ordered. List the most popularproduct ID first and the least popular, last. Resultshould be 2 column table
9. What are the data elements necessary to create aninvoice for a customer? (make sure to have at least customer id,customer name, mailing address, product information that theyordered, quantity of products that they ordered, unit price foreach product and total sales by per customer, order,product.
1.Find the product id and product description for the productwith the highest product standard price.
2.Find how many units of each product have beenordered. Result should be a 2 column table
3.Find the dollar amount of sales for each product. Onyour result, disvplay product description, product standard price,total order quantity per product and sales. Resultshould be 4 column table
4. Find any product which comes in more than onefinishes (assume that any product is offered in at most twodifferent finishes). The result should be a three column table withproduct description, and BOTH finishes listed on the same line. Aproduct should appear only once in the result.Resultshould be 3 column table
5. What product id, product description, product finishhave some sort of ‘Ash’ finish? Result should be 3column table
6. List the customers (customer id and customer name)who live in California or Washington. Result shouldbe 2 column table
7. Determine the average standard price of each productfinish (display product finish and averageprice). Result should be 2 column table
8. For every product that has been ordered, determinethe total quantity that has been ordered. List the most popularproduct ID first and the least popular, last. Resultshould be 2 column table
9. What are the data elements necessary to create aninvoice for a customer? (make sure to have at least customer id,customer name, mailing address, product information that theyordered, quantity of products that they ordered, unit price foreach product and total sales by per customer, order,product.