Beginner
Customers
1. List customers
List the customer portfolio with each customer’s name, industry and country.
clients
SQL practice
SQL exercises
Choose an exercise by level, topic or keyword. Every exercise uses a structured finance database with automatic query validation.
18exercises
3levels
SQLautomatic validation
Local progress
0 / 18 exercises completed
Progress is stored only in this browser.
Catalog
Filter exercises
Beginner
Customers
2. Filter customers located in France
Identify customers located in France to build a domestic analysis scope.
clients
Beginner
Invoicing
3. Invoices above €5,000
Identify significant invoices with a gross amount above €5,000 to prioritize invoice reviews.
factures
Beginner
Invoicing
4. Sort invoices by amount
Sort invoices by gross amount in descending order to identify the largest transactions.
factures
Intermediate
Joins
5. Join customers and invoices
Link each invoice to its customer to analyze invoiced revenue.
clients
factures
Intermediate
Revenue
6. Total invoiced by customer
Calculate the total gross amount invoiced to each customer.
clients
factures
Intermediate
Revenue
7. Customer revenue ranking
Rank customers by their contribution to gross revenue, from highest to lowest.
clients
factures
Intermediate
Tax
8. Total VAT collected
Calculate total VAT collected on sales in this simplified scenario.
factures
Advanced
Tax
9. VAT collected by month
Calculate VAT collected by month to review its trend in the dataset.
factures
Advanced
Cash flow
10. Invoices not fully paid
Identify invoices that have not been fully paid to monitor customer receivables.
clients
factures
reglements
Advanced
Credit management
11. Customer exposure
Calculate financial exposure by customer by aggregating outstanding balances.
clients
factures
reglements
Advanced
Credit management
12. Customer risk ranking
Rank customers by financial exposure to prioritize collection activity.
clients
factures
reglements
Intermediate
Tax
13. Total deductible VAT
Calculate total deductible VAT on purchases in this simplified scenario.
factures_achats
Advanced
Tax
14. Net VAT payable
Calculate net VAT payable by comparing VAT collected on sales with deductible VAT on purchases.
factures
factures_achats
Intermediate
Purchasing
15. Purchases by supplier
Calculate total purchases excluding VAT by supplier to identify the largest spending categories.
fournisseurs
factures_achats
Advanced
Margin
16. Gross margin by product
Calculate a simplified gross margin by product from sales and purchase costs.
produits
lignes_ventes
Advanced
Margin
17. Margin rate by product
Calculate the margin rate by product to compare performance.
produits
lignes_ventes
Advanced
Reporting
18. Top products by revenue
Rank products by revenue excluding VAT to compare their contribution to sales.
produits
lignes_ventes