**********DO NOT USE INNER JOIN, LEFT JOIN, RIGHT JOIN***********

Results Query Type Query Setup Show/Hide All Acc... o Search... EL Query1 SELECT ItemID, Description, (Cost*Units) AS ['OnHandValue'] FROM Baseball Teams, Suppliers WHERE BaseballTeams.ItemID=Suppliers.SupplierCode Tables EEE Baseball Teams Suppliers 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