In MYSQL query, express the following:

1. Bars which are frequented by Jason or Susan but not by both of them

2. Pairs of drinkers and bars such that a drinker frequents the bar and the bar serves at least one beer which the drinker likes

Transcribed Image Text:

Beers(name, manf) Bars(name, addr, license) Drinkers(name, addr, phone) Likes(drinker, beer) Sells(bar, beer, price) Frequents(drinker, bar) Beers(name, manf) Bars(name, addr, license) Drinkers(name, addr, phone) Likes(drinker, beer) Sells(bar, beer, price) Frequents(drinker, bar)

Answer rating: 100% (QA)

Solution Given that point 1 Bas which are frequented by Jason lo... View the full answer