graphs/sql/traffic_offense/req02.sql


1
2
3
4

SELECT * FROM public.traffic_violations
WHERE license_plate LIKE 'AZ__36_'
AND violation_date >= timestamp '2059-12-03 21:00:00' - interval '1 h'
AND violation_date <= timestamp '2059-12-03 21:00:00' + interval '1 h'