Find Top Customer by Year

Hard

Unlock detailed company stats for this questionUpgrade

You are given the following tables:

orders table:

order_id	customer_id	order_date	order_amount	department_id
integer	integer	date	integer	integer

departments table:

department_id	department_name
integer	string

customers table:

customer_id	first_name	last_name
integer	string	string

For each of the last 5 years, identify the customer who placed the most orders, i.e. you should have a list of 5 top customers. Your output should have the following columns: year, customer_id, first_name, last_name, total_orders.

Example output:

year	customer_id	first_name	last_name	total_orders
2020	123	John	Doe	5

Find Top Customer by Year

Categories

Related questions