What is the current contents of the fruit database?

#P1) Display Inventory Contents
Sending query select * from inventory

#P2) Display inventory totals for each fruit in inventory
Sending query select fruitID, sum( quantity ) from inventory group by fruitID

#P3) Display fruit name in alphabetical order
Sending query select name from fruit order by name

#P4) Display fruit contents least expensive first
Sending query select * from fruit order by price ASC

#P5) Display all fruit with price greater than 1, most expensive first
Sending query select * from fruit where price > 1.0 order by price DESC