47

Restaurant Review Summary

MediumJOINAVGCOUNT

Problem Description

Write a SQL query to get average review rating for each restaurant.

Expected Columns

  • restaurant_name
  • avg_rating
  • review_count

Example Output

| restaurant_name | avg_rating | review_count | |-----------------|------------|--------------| | Tandoori Nights | 4.5 | 2 | | Hyderabadi House | 5.0 | 2 | | ... | ... | ... |

Hints

Unlocks after 2 more attempts
Submit your solution to unlock hints

Related Topics

JOINAVGCOUNTGROUP BY
//#47 Restaurant Review Summary
Medium

Loading schema...

Loading editor...

No results yet

Run a query to see results