Scenario-based exercises
SQL with finance and business data
Each topic connects simplified finance data with specific SQL concepts:
joins, aggregations, subqueries and calculations.
Sales
Revenue analysis
Analyze sales by customer, period or product to identify the main revenue contributors.
SQL skills used
JOIN
SUM
GROUP BY
ORDER BY
Relevant tables
clients
factures
lignes_ventes
produits
Related exercises
Tax
VAT scenarios
Calculate VAT collected, deductible VAT and net VAT payable from sales and purchase invoices.
SQL skills used
SUM
Subqueries
Aggregations
Relevant tables
factures
factures_achats
Related exercises
Credit management
Customer overdue balance exercises
Identify partially paid invoices, measure outstanding balances and rank customers by exposure.
SQL skills used
LEFT JOIN
COALESCE
HAVING
ORDER BY
Relevant tables
clients
factures
reglements
Related exercises
Purchasing
Supplier purchasing exercises
Track purchases by supplier and connect purchase invoices with supplier payments.
SQL skills used
JOIN
SUM
GROUP BY
Relevant tables
fournisseurs
factures_achats
paiements_fournisseurs
Related exercises
Margin
Simple gross margin calculations
Calculate product revenue, purchase cost, margin and margin rate by product sold.
SQL skills used
JOIN
Calculations
ROUND
GROUP BY
Relevant tables
produits
lignes_ventes
Related exercises
Dashboard
Metric overview
Present query results as simple metrics: revenue, VAT, margin, cash receipts, cash outflows and overdue balances.
SQL skills used
Aggregations
Metrics
Overview
Relevant tables
factures
factures_achats
reglements
paiements_fournisseurs
Related exercises