You have two tables namely, Customers and Orders. Find the customer(s) who placed the most orders. Print the top 2 customers who placed the MOST orders.
CUSTOMERS
| Column Name | Type |
|---|---|
| id | INT |
| name | VARCHAR(50) |
ORDERS
| Column Name | Type |
|---|---|
| id | INT |
| customerId | INT |
| date | TIMESTAMP |
The output should have one column. The name of the customer(s) who placed the most orders.
| name |
|---|
| Wade Harris |
| Michele Gottlieb |
Expert in Data Structures & Algorithms. Building tools to help developers crack FAANG interviews.