Loading Company...
This is a verified interview question from Quickshell-backend. Candidates reporting seeing this problem in recent Online Assessments (OAs) and onsite rounds. Mastering "Top 2 Customers with Most Orders" covers key patterns like Other.
"### 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 |"
Join thousands of developers practicing for Quickshell-backend.