Question: Use SQL statements to create this table and populate it with this data. Also design and clearly explain at least ten query scenarios that may

Use SQL statements to create this table and populate it with this data.

Also design and clearly explain at least ten query scenarios that may be useful on your database.

Write SQL syntax to answer each query. A query like this: select count(*) from tableOne, can

only be used as one of the ten. Strongly suggested to include some queries using Table Joins,

Aggregates, Group By, Order By, and Having. At least one query must use a view

Order_Quantity Order_Number Amount_to_be_paid Invoice_number Date Time Item_Name Custome_ID
3 101 $15 11 2018-10-05 2:00 BlueBerries 7989
4 102 $28 12 2018-10-05 4:56 Chicken Breast 8997
10 104 $30 13 2018-10-06 5:54 Pork Chop 8978
20 106 $40 14 2018-10-07 7:45 Carrots 2354
5 1025 $39 15 2018-10-08 4:15 Apples 6523
16 1027 $45 16 2018-10-06 2:31 Steak 1274
30 109 $350 17 2018-10-05 3:45 Sour cream 24656
8 105 $45 18 2018-10-07 2:12 Milk 75757
7 453 $50 19 2018-10-09 3:56 Oatmeal 45645
2 754 $10 20 2018-10-05 9:32 Soap 45671

 Use SQL statements to create this table and populate it with

Section Description Bakery Section 1 Good Fruits and Vegetables Section 2 Excellent Frozen foods Section 3 Average Meats Section 4 Excellent Dairy Section 5 Good Breads Section 6 Excellent Cleaning supplies Section 7 Good Personal Hygiene Section Average Pharmacy Section 9 Excellent Canned Goods Section 10 Good

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!