All of the requested SQL statements are based on the table displayed:

1) Provide a listing of all columns and all records from the LGCUSTOMER table

2) Provide a listing of all products, including their Prod_SKU, Prod_Descript, Prod_Type, and Prod_Price whose Quantity on Hand (Prod_QOH) is less than or equal to their minimum (Prod_Min)

3) Insert a record into the LGBRAND table. Specifically, I want to add a record with 45 as the Brand_ID, Apple as the Brand_Name, and Technology as the Brand_Type.

4) Delete all customers from the LGCUSTOMER table with a last name of Smith

5) Provide a listing of Inv_Num, Cust_Code, Inv_Date, and Inv_Total for all invoices between 10-Jan-2016 and 20-Nov-2017

6) Provide a listing of all invoices with the Inv_Num, Inv_Date, Inv_Total, Cust_Fname, Cust_Lname, and Cust_Balavnce fields.

7) Provide a listing of all products with the following fields:

Prod_Descript, Prod_Type, and a computed column of ProdPrice increased by 10%. This computed column should have an alias called NewPrice.

8) Provide the total balance of all customer balances (Cust_Balance) by customer state (Cust_State).

9) Provide a listing of vendors (Vend_ID, Vend_Name, Vend_State) whose state is either Louisiana ("LA") or Texas ("TX").

10) Provide a listing of employees (Emp_Num, Emp_Fname, Emp_Lname) sorted by last name and first name.

FIGURE P7.44 THE CH07 LARGECO ERD LGCUSTOMER LGBRAND PK Brand ID Cust Fname Cust Lname Cust Street Cust City Cust State Cust ZIP Cust Balance Brand Name Brand_Type inclddes es LGLINE PK Prod SKU LGINVOICE PK,FK1 Inv Num Prod Descript Prod_Type Prod Base Prod Category Prod Price Prod QOH Prod_Min FK2 Prod SKU Line_Cty Line Price FK1 Cust Code Inv Date Inv_Total FK2 Employee ID FK1 Brand ID completes by LGEMPLOYEE LGSALARY HISTORY LGSUPPLIES Emp Fname Emp Lname Emp Email Emp_Phone Emp_Hiredate Emp Title Emp_Comm has , IPK,FK1 PK,FK1 Vend ID PK,FK2 Prod SKU PK Sal End Sal Amount FK1 Dept Num pro