!!!!!DO NOT DO THIS IN SQL!!!!

(2a). Create a new table for Suppliers, set the primary key, input data (Note: the supplier data are from Week 1 Assignment). (2b). Change the structure of the original baseball inventory table (Note: we don't need supplier information, so remove SupplierName, and SupplierTelephone, but keep SupplierCode as the foreign key) Then create Access GUI queries (not SQL style, please save each query) (2c). Display item id, description, selling price, supplier name for all items. (2d). Display the item id, description, cost, and units on hand of all items supplied by Beverage Holders (We only know this supplier name as the criteria) (2) Display the average selling price of supplier Beverage Holders' items (We only know this supplier name as the criteria) (26) For each supplier name, find a count of different types of items of the supplier name. Question 3. Use the baseball database you created in question 2 (now you have two tables) for this assignment. Write SQL queries (please save each query): (3a). Display the item id, description, on-hand value (UnitsOnHand* Cost), and supplier name of all items. (3b). Display the average selling price of supplier Logo Goods' (we only know this supplier name as the criteria) items. Use Join (3c). Display the average selling price of supplier Logo Goods' (we only know this supplier name as the criteria) items. Use Subquery/Nestedquery (3d). Display the average selling price of supplier Beverage Holders' items (We only know this supplier name as the criteria) (3e). For each supplier name, find a count of different types of items of the supplier name. (3f). Display item id, description, selling price for the item that has the lowest selling price. Note: when you join two or more tables together, don't use INNER JOIN, LEFT JOIN, RIGHT JOIN format, otherwise, you will get 0 point. Please submit the Access file for Q2 and 23. Query Add Tables All Acc... Search Tables Baseball Suppliers Basebal Tables Linics Quorias All Search Queries 2b Cade Supplier Name Supplier han Description Cost Unite Selling Price Baseball Suppliers 1 Tield Table: Sort Show Criteria or: = C U O Add Selected Tables Ready SOL