Use one and only one SQL Statement to get results for each of the following items.

1. List the name of the customer(s) who ordered the products that have the word alarm in it, together with the Product Name, Unit Price, Order Quantity, sorted by customer name in alphabetical order (A-Z).

2. List the ID, name and average unit cost of the product(s) that has more than one supplier, sorted by the number of suppliers (the highest number of suppliers first).

3. List the ID and name of the product(s) that didnt get ordered by any customer. Use a subquery.

44. Assume the unit prices in Product_T are effective in year 2018, and all product prices had been increasing by 2% each year on January 1^st for the past 5 years, create a new table ProductPrice_History_T to store such changes. Note: Do not alter your Product_T structure or data.

Order T Order ID Orderline T Customer T Order_ID (FK) Product ID (FK) Customer_ID (FK) Order Date Order_Ship_Date Order Total Customer ID Customer Name Line-Quantity-1 Customer_Address CustomerCity Customer_State Customer_ip Customer_Phone Product T Product ID Category_ID (FK) ProductName ProductQuantity ProductUnitPrice --ad Category T Category_ID Category_Name Supplier T Supplier_ID Manufacture T Product_ID (FK) Supplier_ID (FK) Supplier_Name Supplier_Street Supplier_City Supplier_State Supplier_Zip Supplier_Phone ProductUnitCost ProductUnitQuantity