ABC Database 1.Write a query to retrieve customer name, order date, order status using joins. 2....

 

Transcribed Image Text:

ABC Database 1.Write a query to retrieve customer name, order date, order status using joins. 2. Write a query to retrieve customer name, order date, order status without using joins. 3. Write a query to retrieve customer name, order date, and list of ordered products using joins. 4. Write a get list of all products that start with either a' or 'b' or 'c' but ends at 'a'. 5. Write a query to count all the products. 6. Write a query to see list of cancelled orders 7. Write a query to see list of cancelled orders along with customer names. 8. Write a query get the products whose price is greater than average price of products. 9. Write a query to display two columns. One to display list of product categories and second to display the total number of products associated with each category. 10. Create VIEW for customer order details that will display customer name, order number, order data and total amount. And write the script here too. ABC Database 1.Write a query to retrieve customer name, order date, order status using joins. 2. Write a query to retrieve customer name, order date, order status without using joins. 3. Write a query to retrieve customer name, order date, and list of ordered products using joins. 4. Write a get list of all products that start with either a' or 'b' or 'c' but ends at 'a'. 5. Write a query to count all the products. 6. Write a query to see list of cancelled orders 7. Write a query to see list of cancelled orders along with customer names. 8. Write a query get the products whose price is greater than average price of products. 9. Write a query to display two columns. One to display list of product categories and second to display the total number of products associated with each category. 10. Create VIEW for customer order details that will display customer name, order number, order data and total amount. And write the script here too.