
SQL 02 — From tables to decisions
- Pages
- 38 pages
- Language
- Arabic
- Format
- Version
- Version 1.0
Join tables, prepare the data and verify the metrics, then move from results to a decision.
About this guide
It focuses on what changes a number without you noticing, and ends with a branch performance summary you check before sending.
- Who is it for?
- For readers who understand SELECT, WHERE, GROUP BY and row grain, and want metrics from more than one table.
- Scope
- Database administration, data changes and advanced performance are out of scope. A query that works on practice data does not prove a work report is correct.
What you’ll learn
Join tables with JOIN without inflating numbers or dropping branches with no orders.
Prepare readable columns with CASE and CTEs, and handle missing values openly.
Check before sending: order status, the denominator and what the table does not say.
A mini project: a 2025 branch table of orders, sales and average order value.
Practice pack
Data and exercise files shared by SQL 01 and SQL 02 (ZIP).
Download the pack
