From our clients we receive two files and imported the to a database:
- vehicles.csv → a list of trucks
- Trackings.csv → vehicle data with timestamp ("time") and position ("lat", "lng") • Consider and treat these files as if they were tables • Both tables can be matched via the vehicle_id. Please answer the following questions via a SQL script:
- Which vehicles are active/inactive (in the sense of having tracking data at all)? Result table with two columns: vehicle_id, active_Boolean
SELECT v.vehicle_id,