Question: Show the effects of the following SQL retrieval operations on the wine cellar database of Fig: a. SELECT WINE, PRODUCER. FROM CELLAR WHERE BIN# =

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;

Step by Step Solution

3.42 Rating (168 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Show the effects of the following SQL retrieval operations on ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

CS-DB (13).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!