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, dont use INNER JOIN, LEFT JOIN, RIGHT JOIN format, otherwise, you will get 0 point.