All Problems
67

Menu Items per Restaurant

MediumJOINCOUNTGROUP BY

Problem Description

Write a SQL query to count menu items available at each restaurant.

Expected Columns

  • restaurant_name
  • item_count

Example Output

| restaurant_name | item_count | |-----------------|------------| | Tandoori Nights | 3 | | Dakshin Delight | 3 | | ... | ... |

Hints

Unlocks after 2 more attempts
Submit your solution to unlock hints
//#67 Menu Items per Restaurant
Medium

Loading schema...

Loading editor...

No results yet

Run a query to see results