Oracle NextGen

SQL Challenge

Challenge #10 – Monthly Sales Trend

Challenge Overview

Calculate total sales for each month in 2024 and show the month name and total.

Requirements

•Return columns: month_name, total_sales.
•Extract month from sale_date and format as month name.
•Sum all sales amounts per month.
•Order by month chronologically (January to December).

Sample Dataset

Preview the schema and seeded rows you can query against.

sales

Daily sales transactions.

Columns

Name	Type	Notes
sale_id	INT	Primary key
sale_date	DATE	Sale date
amount	DECIMAL	Sale amount

Sample Rows

sale_id	sale_date	amount
1	2024-01-15	200
2	2024-01-20	300
3	2024-02-10	450
4	2024-03-05	350
5	2024-03-25	400

SQL Playground

Loading editor…

Result Preview

Awaiting Run

Run your query to see the dataset preview.