Write sql statements to perform the following operations on


Question: Write SQL statements to perform the following operations on the wine cellar database:

(a) Retrieve bin number, name of wine, and number of bottles for all Geyser Peak wines.

(b) Retrieve bin number and name of wine for all wines for which there are more than five bottles in stock.

(c) Retrieve bin number for all red wines.

(d) Add three bottles to bin number 30.

(e) Remove all Chardonnay from stock. (0 Add an entry for a new case (12 bottles) of Gary Farrell Merlot: bin number 55, year 91, ready in 96.

Request for Solution File

Ask an Expert for Answer!!
Database Management System: Write sql statements to perform the following operations on
Reference No:- TGS02324236

Expected delivery within 24 Hours