#1 fruit database display inventory contents
SELECT * FROM `inventory`;

#2 fruit database display inventory totals for each fruit available
SELECT fruitID, sum(quantry) FROM `inventory` GROUP BY fruitID;

#3 display fruit names ordered alphabetically
SELECT `name` FROM `fruit` ORDER BY name;

#4 display least expensive fruit first
SELECT * FROM  `fruit` ORDER BY  `fruit`.`price` ASC;

#5 display fruit price > 1 (most expensive first)
SELECT * FROM  `fruit` WHERE `price` > 1.0 ORDER BY  `price` DESC;