3. Suppose we have a relation yelp that contains millions of Yelp reviews for restaurants in...

Transcribed Image Text:

3. Suppose we have a relation yelp that contains millions of Yelp reviews for restaurants in the Los Angeles area. It has the form yelp(id, name, address, stars, review_text) with id as a key. Write a query that returns all Starbucks locations that have an average rating greater than 4 stars. You must return at least the name (Starbucks), the address, and the average stars (call it avg-stars) for locations that match my requirement. Order them in descending order by average rating. Be careful! Remember the SQL standard. 3. Suppose we have a relation yelp that contains millions of Yelp reviews for restaurants in the Los Angeles area. It has the form yelp(id, name, address, stars, review_text) with id as a key. Write a query that returns all Starbucks locations that have an average rating greater than 4 stars. You must return at least the name (Starbucks), the address, and the average stars (call it avg-stars) for locations that match my requirement. Order them in descending order by average rating. Be careful! Remember the SQL standard.