1
Beginner
Query and filter data
Objective: learn how to query a table, select columns, filter rows and sort results.
Recommended learning path
A structured path for learning SQL progressively with simplified finance, accounting and business data.
Learning progress
View exercises
0 / 18 exercises completed
Completed exercises are stored locally in your browser.
2
Beginner
Sort and organize results
Objective: structure a query to produce a clear, usable result.
3
Intermediate
Connect tables with JOIN
Objective: understand relationships between customers, invoices, payments, suppliers, purchases and products.
4
Intermediate
Aggregate finance data
Objective: produce metrics with SUM, COUNT, GROUP BY and HAVING: revenue, purchases, VAT and customer groupings.
5
Advanced
Query VAT, overdue balance and margin data
Objective: combine multiple SQL concepts in finance scenarios: net VAT payable, unpaid invoices, customer exposure, gross margin and margin rate.
6
Overview
Build an overview
Objective: present query results as simple dashboard metrics: revenue, VAT, margin, cash flow and overdue balances.