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) |
Basic
The example input, expected output, and walkthrough for this question unlock with a Basic plan.
Basic
The reference solution and walkthrough for this question unlock with a Basic plan.
See Basic plansRM 25/mo · cancel anytime
Basic
This is a Basic question
Premium practice questions unlock with a Basic plan. The full solution, expected output, and grading are available to Basic members.
RM 25/mo · cancel anytime