/* To retrieve all Coffee Products from the CoffeeProduct Table based on the Coffee Category and order by CoffeeCategory */


SELECT Product_Name, Description, Price, Origin, Roast, Size, Grind, SpecialOffers, Image_ID FROM CoffeeProduct 
ORDER BY CoffeeCategory_ID DESC;

/* 

To retrieve some Coffee Products from the CoffeeProduct Table based on the Coffee Category and order by CoffeeCategory */


SELECT Product_Name, Description, Price, Origin, Roast, Size, Grind, SpecialOffers, Image_ID FROM CoffeeProduct 
WHERE CoffeeCategory_ID= 'CoffeeCategory'
ORDER BY CoffeeCategory_ID DESC;



/* To retrieve a Coffee Product from the CoffeeProduct Table based on the Coffee Name */


SELECT Product_Name, Description, Price, Origin, Roast, Size, Grind, SpecialOffers, Image_ID FROM CoffeeProduct 
WHERE Product_Name= 'Roast';




/* To retrieve Merchandise Products from the MerchaniseProducts Table and order based on Alphabetical Name. */


SELECT Product_Name, Manufacturer, Description, Price, Image_ID, SpecialOffers FROM MerchandiseProduct
 ORDER BY Product_Name DESC;



/* To retrieve a Merchandise Product from the MerchaniseProducts Table based Name. */ 

SELECT Product_Name, Manufacturer, Description, Price, Image_ID, SpecialOffers FROM MerchandiseProduct WHERE Product_Name= 'Spoon';




/* To retrieve Images from the Images Table */


SELECT Image  FROM Images
WHERE Product_ID=Product_ID;




/* To place data from Inquiry Fields into Database */


INSERT INTO Inquiry (Contact_First, Contact_Last, InquiryType_ID, BusinessType_ID, Email, Phone, Details)

VALUES (Sheldon, James, 1, 1, sheldon@gmail.com, 5555553344, This is a detialed inquiry);