Question: need answer for question 7. database layout on right with primary key in respective tables underlined. need complete query answer. Consider the beer drinker's database

need answer for question 7. database layout on right with primary key in respective tables underlined. need complete query answer.
Consider the beer drinker's database s underlined 6 Find all drinkers who frequent every bar that serves some beers they like Name Location Tony TrotterellMontlake Drinker (name, address) Bar (name, address) Beer (name, brewer) Frequents (drinker, bar, times_a_ week) Likes (drinker, beer) Serves (bar, beer, price) 7. Find those drinkers who enjoy exactly the same set of beers as Silvie Hume Name Andrey Waterville Greek row 8. For each beer, find the bars that serve it at the lowest price Bar Beer Bhagwan's Best IPA Big Time Brewery 5.75 Prime Time Pale Ale Big Time Brewery 5.5 Mac and Jack's Amber College Inn Bud light Budweiser Heincken Rainier Beer Price Answer the following questions: Dantes Dantes Dante's Dantes 1. Find all drinkers who frequent Big 2.25 names and addresses
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
