Show the effects of the following SQL update operations on the wine cellar database of fig: a.

Question:

Show the effects of the following SQL update operations on the wine cellar database of fig:
a. INSERT INTO CELLAR(BIN#, WINE, PRODUCER, YEAR, BOTTLES, READY) VALUES(80, ‘Syrah’, ‘Meridian’, 1998, 12, 2003);
b. DELETE FROM CELLAR WHERE READY > 2004;
c. UPDATE CELLAR SET BOTTLES = 5 WHERE BIN# = 50;
d. UPDATE CELLAR SET BOTTLES = BOTTLES + 2 WHERE BIN# = 50;