Challenges - Second Exercise Solution

new_solution.sql

UPDATE vehicles SET registration_date = CURRENT_DATE - INTERVAL '11 months' WHERE id = 1;
UPDATE vehicles SET registration_date = CURRENT_DATE - INTERVAL '12 months' WHERE id = 2;
UPDATE vehicles SET registration_date = CURRENT_DATE - INTERVAL '18 months' WHERE id = 3;
UPDATE vehicles SET registration_date = CURRENT_DATE - INTERVAL '20 months' WHERE id = 4;


SELECT d.first_name, d.last_name, v.make, v.model, v.registration_date
FROM drivers d
JOIN vehicles v ON d.id = v.driver_id
WHERE v.registration_date = CURRENT_DATE - INTERVAL '11 months';