Use the baseball database you created for this assignment (Note: please copy the Access file and paste, give a name like BaseballLec02). Create Access queries (each question needs a query, please save each query)

(a)Display the item id, description, cost, and units on hand of all items supplied by Beverage Holders (We only know this criteria)

(b) Display the item id, description, and on-hand value (unitsonhand*cost) of all items.

(c)Display the item id, description, units on hand, and current profit (sellingprice cost) of all items that have a selling price greater than $15.

(d) Find the lowest and highest selling price

(e) Display the average selling price of supplier BHs items

(f) Find a count of different types of items grouped by supplier names

Please use SQL statements to answer the above questions again.