IntermediateRetailSQL+20 XP

Revenue by category with a sales threshold

Scenario

You are a data analyst. A grocery chain is deciding which categories get extra shelf space next quarter. Merchandising wants revenue per category, but only categories that actually move.

Question

Show category and total revenue (quantity * unit_price) for categories with revenue above 5000, highest first.

Your task

Aggregate revenue per category
Keep only categories above 5000
Order by revenue descending

SQLGROUP BYAggregationHAVING

Read the simple theory: SQL

Intermediate · Record Counting & Average Calculations — question 11 of 30

Finish all 30 to earn a certificate

1. Choose your dataset

Pick an industry and a size. Your code and results change to match.

IndustrySize

sql editorstore_sales

Snippets

💡 Explain my whole code, line by line (hover any word in the editor for a tip)

🌈 In short — no coding words

📂 Opens the "store_sales" table→✅ Shows you the answer

Altogether: this query reads your industry table, picks what you need, and shows the answer as rows.

Start typing to see suggestions. Press Enter to use one. Red marks show the line to fix. Drag a bottom corner horizontally and vertically to resize.

Type your code here ↓Tap or click inside the box to start

✍️ Tap here to type

Dataset & schema

store_sales

IndustryDataset size

The tiny starter data. Bigger data scrolls.

Fields

sale_id	category	quantity	unit_price	store
1	Beverages	120	24.5	Sandton
2	Bakery	300	12	Sandton
3	Beverages	210	24.5	Durban
4	Household	40	89	Durban
5	Bakery	150	12	Cape Town

attempts: 0

▶ Output terminal

$ Press “Check my answer” — results appear here.

Your next steps

Each item turns green when your answer includes it.

4 left

Sums revenue
Groups by category
Filters aggregate with HAVING
Orders descending