mediumFoodpanda · aggregationPro
Top 3 restaurants by orders
Foodpanda wants its three busiest restaurants.
From the orders table, return the restaurant and its number of orders as order_count, for the top 3 restaurants by order count, most orders first.
Schema
▸orders
| id | INT |
| restaurant | TEXT |
| amount | NUMERIC(8,2) |
Pro
The example input, expected output, and walkthrough for this question unlock with a Pro plan.
Pro
This is a Pro question
Premium practice questions unlock with a Pro plan. The full solution, expected output, and grading are available to Pro members.