Answers below questions by writing SQL statements and with screen prints where mentioned. Create table name...

Transcribed Image Text:

Answers below questions by writing SQL statements and with screen prints where mentioned. Create table name stating with your Campus ID. Example AX23456_TableName T_Customer_22 Customerld PK TO First Name Last_name Zip_Code T_Order_22 Id OrderDate OrderNumber Customerld FK TotalAmount PK +0 T_Orderltem_22 PK +0 FK Id Orderld Productid UnitPrice Quantity FK T_Product_22 Id PK +0 ProductName UnitPrice 1- [Pts 4] Create three table, define constrains (PK, FK and Not Null) [Pts 1], data type, size [Pts 1] and Syntax [Pts 1]. Table Name = Your Campus ID_ Table Name. 2- [Pts 5] Inserts records in each table a. [Pts 1 ] Insert 3 T_Customer_22 b. [Pts 1 ] Insert 5 T_Products_22 c. [Pts 2] Insert 2 orders (Req Screen Print) d. [Pts 3] Insert order details (At least 3 items for each order) (Req Screen Print) 3- [Pts 15] Write below queries - (Required Screen Print for d, g and i) a. [Pts 1] Write SQL, Display Order filter/search by OrderDate and First_Name b. [Pts 1] Write SQL, Display total Sales Between )1/01/2020 and 08/01/2020 c. [Pts 1.5] Write SQL, Display OrderDate, OrderNumber, ProductId, UnitPrice and Qunatity from T_Order_22 and T_Orderitem_22. d. [Pts 1.5] Write SQL, Display OrderDate, OrderNumber, ProductName, and Qunatity from T_Order_22, T_Orderitem_22 and T_Product_22. e. [Pts 1.5] Write SQL, Display OrderDate, OrderNumber, ProductName, and Quantity from T_Order_22, T_Orderitem_22 and T_Product_22 filter/search by CustomerID f. [Pts 1.5] Write SQL, Display ProductName sales show max count in Asc order g. [Pts 1.5] Write SQL, Display OrderDate, Order Number, CustomerName, ProductName, Quantity and Total Price/Amount h. [Pts 1.5] Write SQL, Display Zip Code with most Sales Answers below questions by writing SQL statements and with screen prints where mentioned. Create table name stating with your Campus ID. Example AX23456_TableName T_Customer_22 Customerld PK TO First Name Last_name Zip_Code T_Order_22 Id OrderDate OrderNumber Customerld FK TotalAmount PK +0 T_Orderltem_22 PK +0 FK Id Orderld Productid UnitPrice Quantity FK T_Product_22 Id PK +0 ProductName UnitPrice 1- [Pts 4] Create three table, define constrains (PK, FK and Not Null) [Pts 1], data type, size [Pts 1] and Syntax [Pts 1]. Table Name = Your Campus ID_ Table Name. 2- [Pts 5] Inserts records in each table a. [Pts 1 ] Insert 3 T_Customer_22 b. [Pts 1 ] Insert 5 T_Products_22 c. [Pts 2] Insert 2 orders (Req Screen Print) d. [Pts 3] Insert order details (At least 3 items for each order) (Req Screen Print) 3- [Pts 15] Write below queries - (Required Screen Print for d, g and i) a. [Pts 1] Write SQL, Display Order filter/search by OrderDate and First_Name b. [Pts 1] Write SQL, Display total Sales Between )1/01/2020 and 08/01/2020 c. [Pts 1.5] Write SQL, Display OrderDate, OrderNumber, ProductId, UnitPrice and Qunatity from T_Order_22 and T_Orderitem_22. d. [Pts 1.5] Write SQL, Display OrderDate, OrderNumber, ProductName, and Qunatity from T_Order_22, T_Orderitem_22 and T_Product_22. e. [Pts 1.5] Write SQL, Display OrderDate, OrderNumber, ProductName, and Quantity from T_Order_22, T_Orderitem_22 and T_Product_22 filter/search by CustomerID f. [Pts 1.5] Write SQL, Display ProductName sales show max count in Asc order g. [Pts 1.5] Write SQL, Display OrderDate, Order Number, CustomerName, ProductName, Quantity and Total Price/Amount h. [Pts 1.5] Write SQL, Display Zip Code with most Sales