Customer Placing The Largest Number Of Orders Problem


Description

LeetCode Problem 586.

Query the customer_number from the orders table for the customer who has placed the largest number of orders.

It is guaranteed that exactly one customer will have placed more orders than any other customer.

The orders table is defined as follows:

1
2
3
4
5
6
7
8
9
| Column            | Type      |
|-------------------|-----------|
| order_number (PK) | int       |
| customer_number   | int       |
| order_date        | date      |
| required_date     | date      |
| shipped_date      | date      |
| status            | char(15)  |
| comment           | char(200) |

Sample Input

1
2
3
4
5
6
| order_number | customer_number | order_date | required_date | shipped_date | status | comment |
|--------------|-----------------|------------|---------------|--------------|--------|---------|
| 1            | 1               | 2017-04-09 | 2017-04-13    | 2017-04-12   | Closed |         |
| 2            | 2               | 2017-04-15 | 2017-04-20    | 2017-04-18   | Closed |         |
| 3            | 3               | 2017-04-16 | 2017-04-25    | 2017-04-20   | Closed |         |
| 4            | 3               | 2017-04-18 | 2017-04-28    | 2017-04-25   | Closed |         |

Sample Output

1
2
3
| customer_number |
|-----------------|
| 3               |

Explanation

1
2
The customer with number '3' has two orders, which is greater than either customer '1' or '2' because each of them  only has one order. 
So the result is customer_number '3'.


MySQL Solution

1
2
3
4
5
select customer_number
from orders
group by customer_number
order by count(customer_number) desc
limit 1




Related Posts

Investments In 2016 Problem

LeetCode 585. Write a query to print the sum of...

Count Student Number In Departments Problem

LeetCode 580. A university uses 2 data tables, student and...

Classes More Than 5 Students Problem

LeetCode 596. Please list out all classes which have more...

Find Customer Referee Problem

LeetCode 584. Given a table customer holding customers information and...

Customer Placing The Largest Number Of Orders Problem

LeetCode 586. Query the customer_number from the orders table for...

Big Countries Problem

LeetCode 595. Write a SQL solution to output big countries’...