20091011_oracle_sql

 

Consider the following relational database schema. It is intended to represent who will eat what
kinds of sandwiches and the places which serve the various kinds of sandwiches. A sample
database instance is also given.

 

 

Write SQL statements to retrieve the following information:
(i) places where Jones can eat (using a nested subquery).

 

SELECT ADDRESS FROM Locations WHERE LNAME IN
(SELECT LOCATION from sandwiches where FILLING in
(SELECT FILLING FROM tastes WHERE NAME = 'Jones'))

(ii) places where Jones can eat (without using a nested subquery).

 

(ii) for each location the number of people who can eat there.