Solve the following queries: 1. Display all details of the item table. 2. Display item name, section and price of all garments. 3. Display the number of customers from Muscat and their total amount....

Solve the following queries: 1. Display all details of the item table. 2. Display item name, section and price of all garments. 3. Display the number of customers from Muscat and their total amount. 4. Display the average of all garment items sold. 5. Display the maximum and minimum amount of the customer. 6. Display all items ending with ‘et’ and are décor. 7. Display customer number and location of customer with amount not less than 50. 8. Display all garments and décor items. 9. Display all décor items with prices not less than 10. 10. Display item name, section and price of all accessories with price less than equal to 5. 11. Display the average amount of Nizwa city customers. 12. Display all items with price between 5 and 10. (without using between) 13. Remove duplicate values from the section column of the item table. 14. Display item name, price, customer number of C2 customer.

Jun 02, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here