COP4521 Homework 5

Name:                         FSU login:

Write SQL queries that achieve the following: 

1) (20 points) From relation Sells(bar, beer, price),
find the bars that sell 'Bud Lite' for no more than $3.00.














2) (20 points) Using relations Likes(drinker, beer) and
Sells(bar, beer, price), find the bars that sell at least a beer that
Sally likes, the beers (that Sally likes), and the prices. 












3) (20 points) Using relations students(Sid, SSN, LName, FName, Phone, GPA)
and takes(Sid, course), find the student id (Sid), and first names (FName)
and last names (LName) of students who take COP4521 and COP4610.












4) (20 points) Using relations Sells(bar, beer, price),
Frequents(drinker, bar), and Likes(drinker, beer), find the average
price of beers that Sally likes at the bars she frequents.










5) (20 points) Using Frequents(Drinker, bar), insert into a new
relation Buddies(name) all of Sally and Robert's potential drinking
buddies who frequent at least one bar that both Sally and Robert
frequent.