Question: Show the database effects operations on the wine cellar

Show the effects of the following SQL retrieval operations on the wine cellar database of Fig:
a. SELECT WINE, PRODUCER.
FROM CELLAR WHERE BIN# = 72 ;
b. SELECT WINE, PRODUCER
FROM CELLAR WHERE YEAR > 2000;
c. SELECT BIN#, WINE, YEAR
FROM CELLAR WHERE READY < 2003;
d. SELECT WINE, BIN#, YEAR
FROM CELLAR WHERE PRODUCER = ‘Robt Mondavi’ AND BOTTLES > 6;
View Solution:


Sale on SolutionInn
Sales0
Views330
Comments
  • CreatedNovember 03, 2009
  • Files Included
Post your question
5000