Describe your experience with business-flavored SQL and how you have used it to drive operational decisions at Waymo.
For this exercise, use the supplied Waymo trip and trip event records to produce a concise operational summary for the first quarter of 2025.
city, report_month, total_trips, completed_trips, cancellation_rate_pct, safety_event_count, and avg_completed_eta_variance_seconds.| Column | Type | Description |
|---|---|---|
| trip_idPK | INT | Unique trip identifier |
| city | VARCHAR(100) | Operational city where the trip occurred |
| requested_at | TIMESTAMP | Timestamp when the trip was requested |
| status | VARCHAR(20) | Trip outcome |
| eta_variance_seconds | INT | Actual arrival variance from the estimated arrival time |
| Column | Type | Description |
|---|---|---|
| event_idPK | INT | Unique trip event identifier |
| trip_id | INT | Trip associated with the event |
| event_type | VARCHAR(40) | Operational event category |