Top 2 Customers with Most Orders

Question

### Problem
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.

### Table Structure:

**CUSTOMERS**
| Column Name | Type |
| --- | --- |
| id | INT |
| name | VARCHAR(50) |

**ORDERS**
| Column Name | Type |
| --- | --- |
| id | INT |
| customerId | INT |
| date | TIMESTAMP |

### Answer Structure
The output should have one column. The name of the customer(s) who placed the most orders.

| name |
| --- |
| Wade Harris |
| Michele Gottlieb |

Accepted Answer

See solution code in the editor.

Top 2 Customers with Most Orders

Problem

Table Structure:

Answer Structure

Top 2 Customers with Most Orders

Problem

Table Structure:

Answer Structure

Author: Amit Dayal

Up Next

Snapshot Upload 2026-04-13 13:39:17

Implement runSequentially Function

File Existence Check

Customers with Unshipped Orders

The Bishops Path