Write SQL statements to perform the following operations on the wine cellar database: a. Get bin number,

Question:

Write SQL statements to perform the following operations on the wine cellar database:
a. Get bin number, name of wine, and number of bottles for all Geyser Peak wines.
b. Get bin number and name of the wine for all wines for which there are more than five bottles in the stock. c. Get bin number for all red wines.
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Oracle 11G SQL

ISBN: 9781133947363

2nd Edition

Authors: Joan Casteel

Question Posted: