Loading…

Track SQL for Analysis

Sales Analysis Capstone

9 / 9

SQL for Analysis

Course Progress0/9

Advanced Filtering

Pattern Matching with LIKE NULL Handling

Joining Tables

Introduction to JOINs LEFT and RIGHT JOINs

Subqueries

Subqueries in WHERE Subqueries with Aggregates

Window Functions

Introduction to Window Functions PARTITION BY

Capstone Project

Sales Analysis Capstone

SQL

Revenue by Category

Capstone Challenge 1: Revenue Analysis

Calculate the total revenue for each product category.

Requirements:

Join products with order_items
Group by category
Calculate: total revenue (quantity × price)
Order by revenue descending

query.sql

Loading SQL engine...

Downloading SQL engine… (one-time)

Downloading SQL engine… (one-time)

This runs entirely in your browser and is cached for next time.

Click "Submit" to check your answer