SQL
Scenario-based exercises
Practice with simplified sales, purchases, invoices, payments, products and supplier data.
SQL · Finance · Accounting
Finance database online
Learn SQL with realistic finance data.
Build practical SQL skills with realistic finance and accounting data covering revenue, VAT, margins, payments and customer receivables.
18exercises with solutions
8relational tables
0completed locally
01
SELECT c.nom_client, f.id_facture,02
f.montant_ttc - COALESCE(SUM(r.montant_regle), 0)03
AS reste_a_payer04
FROM clients c05
JOIN factures f ON c.id_client = f.id_client06
LEFT JOIN reglements r ON f.id_facture = r.id_facture;
Query executed
6.4 ms
clientfactureoutstanding balance
Nova TipF-10424 820 €
Orion RetailF-10482 450 €
01Write
02Run
03Analyze
Why SQL Finance Trainer
From SQL syntax to business data analysis
A structured practice environment for learning SQL through realistic finance scenarios.
OK
Automatic validation
Validate each result automatically and learn from clear feedback.
DB
Relational schema
Understand keys and relationships before writing reliable joins.
CSV
Exportable results
Export SQL results to CSV for further analysis.
18
Visible progress
Track completed exercises locally and progress from SELECT to advanced analysis.
KPI
Business context
Interpret VAT, margins, receivables and revenue beyond the raw query result.
Learning workflow
A structured approach from scenario to result.
Every exercise follows the same steps to build reliable SQL habits.
View the learning path →Read the scenario
Identify the finance objective and the relevant data.
Write the query
Choose the relevant tables, filters, joins and aggregations.
Run
Run the query directly against the SQLite database.
Analyze
Review the returned rows and check their consistency.
Compare
Validate the result and understand the solution.
Relational model in action
See how finance data connects
id_client · nom · paysJOINid_client
montant_ht · tva · ttcLEFT JOINid_facture
date · montant_regle
Available finance scenarios
Practical calculations for SQL practice
Customer receivables
Outstanding invoices
Calculate and rank outstanding balances.
JOIN · LEFT JOIN · COALESCE → Business calculationsGross margin
Calculate simple margins from sales and costs.
SUM · GROUP BY → ExampleVAT
Work with VAT collected and deductible VAT in simplified exercises.
Subqueries · Calculations → Cash flowCustomer receivables
Measure financial exposure by customer account.
HAVING · Aggregations → ReportingRevenue
Analyze sales by customer, product and period.
Dashboard · KPI → Cash receiptsPayments
Compare invoiced and paid amounts.
Relations · Calculations →Ready to practice?
Build practical SQL skills with finance-oriented data.
Start with a finance scenario, run your first query and validate the result.