Find Revenue by Department

Medium

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

Order the departments from highest to lowest revenue in the last 12 months. Your output should have the following columns: department_name, total_revenue

Find Revenue by Department

Categories

Related questions