Interview Guides

Monthly Sales Summary for Store

EasyJoinsData Wrangling

Problem

NovaCart wants a simple monthly sales report for completed orders. Write a SQL query to summarize revenue and order volume by month using only the orders table.

Requirements

Return one row per month for completed orders only.
Show the month as YYYY-MM, the number of completed orders, and total revenue.
Sort the result by month ascending.

Table Definition

orders

column_name	type	description
order_id	INT	Unique order identifier
customer_name	VARCHAR(100)	Customer name
order_date	DATE	Date the order was placed
status	VARCHAR(20)	Order status such as completed, cancelled, or pending
amount	DECIMAL(10,2)	Order amount

Problem

NovaCart wants a simple monthly sales report for completed orders. Write a SQL query to summarize revenue and order volume by month using only the orders table.

Requirements

Return one row per month for completed orders only.
Show the month as YYYY-MM, the number of completed orders, and total revenue.
Sort the result by month ascending.

Table Definition

orders

column_name	type	description
order_id	INT	Unique order identifier
customer_name	VARCHAR(100)	Customer name
order_date	DATE	Date the order was placed
status	VARCHAR(20)	Order status such as completed, cancelled, or pending
amount	DECIMAL(10,2)	Order amount

Practice SQL

PostgreSQL

Open on desktop for the full SQL editor with syntax highlighting and autocomplete.

Up next

Monthly Sales Summary by CategoryEasy Monthly Revenue Trends by CategoryMedium Monthly Customer Spend and RankMedium

Next question

Monthly Sales Summary for Store | Dataford Interview Questions