SQLCase
Home / Intermediate
Intermediate

Intermediate track

Window functions, CTEs, self-joins, and set operations. 15 cases.

Window Functions
CASE 021

The Leaderboard

customersorderspayments
✓
CASE 022

The Latest Order

orders
✓
CASE 023

Before and After

orders
✓
CASE 024

The Running Total

customersorderspayments
✓
CASE 025

The Tie Breaker

customersorders
✓
Self-Joins & CTEs
CASE 026

Bought Together

order_itemsproducts
✓
CASE 027

Bought Both

customersordersorder_items
✓
CASE 028

The High-Value Customers

customersorderspayments
✓
CASE 029

The Second Order

orders
✓
CASE 030

Signup Cohorts

customers
✓
CASE 031

Did They Come Back?

customersorders
✓
Business Calculations
CASE 032

Paid vs. Unpaid

customersorderspayments
✓
CASE 033

Profit Margin

productsinventory
✓
CASE 034

At-Risk Stock

productsinventoryorder_items
✓
CASE 035

The Churn Signal

customersorders
✓

Looking for a different level?

BeginnerAdvanced