Question: Create a database store Create the table using design view. Item Price Sold Customer No 3 25 C1 Section Garments Accessories Garments Accessories 7 ItemID

 Create a database store Create the table using design view. Item

Create a database store Create the table using design view. Item Price Sold Customer No 3 25 C1 Section Garments Accessories Garments Accessories 7 ItemID Item Name IT101 Tshirt IT102 Handbag IT103 Socks IT104 Bracelet IT105 Blanket IT106 Pillow 12 C2 1 20 CI 5 5 C3 Dcor 12 9 C2 Dcor 10 32 04 Create the table using SQL Create statement. Customer Customer No Location PurDate CI Nizwa 2/25/2021 C2 Muscat 2/24/2021 2/22/2021 Nizwa 2/22/2021 Amount 30 45 C3 Muscat SS C4 60 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 decor. 7. Display customer number and location of customer with amount not less than 50

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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 Databases Questions!