Write an SQL query to join vehicle telemetry events with vehicle metadata and return the latest event per vehicle. Use the provided tables. Return only vehicles with matching telemetry, select the event with the greatest timestamp, and use the greatest event ID to break timestamp ties.
vehicle_id, vin, model, event_id, event_timestamp, event_typevehicle_id ascending| Column | Type | Description |
|---|---|---|
| vehicle_idPK | INT | Internal vehicle identifier |
| vin | VARCHAR(17) | Vehicle identification number |
| model | VARCHAR(50) | Vehicle model name |
| model_year | INT | Vehicle model year |
| assembly_plant | VARCHAR(80) | Vehicle assembly plant |
| Column | Type | Description |
|---|---|---|
| event_idPK | INT | Unique telemetry event identifier |
| vehicle_id | INT | Vehicle associated with the event |
| event_timestamp | TIMESTAMPTZ | Time when the event was recorded |
| event_type | VARCHAR(40) | Telemetry event classification |
| speed_kph | DECIMAL(6,2) | Vehicle speed in kilometers per hour |
| battery_percent | DECIMAL(5,2) | Battery charge percentage |