1. Engineering
  2. Computer Science
  3. use the baseball database you created for this assignment note...

Question: use the baseball database you created for this assignment note...

Question details

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 BH’s items

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

Please use SQL statements to answer the above questions again.

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution