Tell me about a time you used SQL to solve a business problem, and walk me through how you validated your results.
For this exercise, use the booking records and reported daily metrics to demonstrate the SQL portion of that answer. Recalculate confirmed booking counts and values, compare them with the reported figures, and identify missing or mismatched records.
metric_date, market, calculated and reported metrics, both differences, and validation_status.| Column | Type | Description |
|---|---|---|
| booking_idPK | INT | Unique booking identifier |
| booking_date | DATE | Date on which the booking was recorded |
| market | VARCHAR(20) | Market associated with the booking |
| booking_status | VARCHAR(20) | Booking lifecycle status |
| booking_value | NUMERIC(12,2) | Value attributed to the booking |
| Column | Type | Description |
|---|---|---|
| metric_datePK | DATE | Date of the reported metric |
| marketPK | VARCHAR(20) | Market represented by the report |
| reported_bookings | INT | Booking count from the report |
| reported_value | NUMERIC(12,2) | Booking value from the report |