Your question is Find Overlapping Anomalous Coordinates. Start with the requirements and the two tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
Zoox engineers want to identify locations where anomalous path-planning adjustments affected multiple autonomous vehicles. Because GPS readings can differ slightly, treat coordinates rounded to four decimal places as the same location.
Write a PostgreSQL query to identify overlapping anomalous coordinates from the provided tables.
| Column | Type | Description |
|---|---|---|
| vehicle_idPK | INT | Unique identifier for an autonomous vehicle |
| vehicle_name | VARCHAR(80) | Internal Zoox vehicle name |
| fleet_status | VARCHAR(30) | Current operating status of the vehicle |
| Column | Type | Description |
|---|---|---|
| event_idPK | INT | Unique path-planning event identifier |
| vehicle_id | INT | Vehicle associated with the event |
| event_time | TIMESTAMP | Time when the planning adjustment occurred |
| latitude | NUMERIC(9,6) | Recorded latitude |
| longitude | NUMERIC(9,6) | Recorded longitude |
| anomaly_flag | BOOLEAN | Whether the event was classified as anomalous |
| adjustment_type | VARCHAR(40) | Type of path-planning adjustment |
| adjustment_meters | NUMERIC(6,2) | Magnitude of the path adjustment in meters |