SQL_Queries_Solutions

Student’s Name Professor’s Name Course Date SQL Queries Solutions PART A) LIKES(drinker,beer); /* key: all columns */ FREQUENTS(drinker,pub); /* key: all columns */ SERVES(_pub,beer_,cost); /* key: (pub,beer) */ Find pubs that serve some beer that Joe likes SELECT S.pubs FROM Serves S, Likes L WHERE L.drinker = Joe & L.beer