Question

Consider a database with the following schema.

BARS(name,license,city,phone,addr);

BEERS(name,manf);

DRINKERS(name,city,phone,addr);

LIKES(drinker,beer); 

FREQUENTS(drinker,bar); 

SELLS(bar,beer,price); 

Return SQL code for the following queries.

1.  Find all distinct drinkers whose phone numbers come from area code 917 and who like Budweiser or Bud (synonim!)

2. What beers does Mike like?

3. Which town has the most drinkers?

4. What bars are frequented by drinkers from that town (3)?

5. Provide all bars which serve beers that Mike likes

6. Who likes the at least one same beer that Joe or Mike like?

7.  All bars which sell at last one beer which is liked by at least one drinker who frequents these bars

8. Drinkers who like some beers sold by Caravan bar

9. Bars which sell Budweiser and are frequented by some drinkers who like Budweiser

10.  Bars which are frequented by Mike  and Steve

11. Drinker who like at least two beers that Mike likes

12. Bars which sell at least 3 beers that Mike likes (do not use COUNT)

Answer 1