summaryrefslogtreecommitdiff
path: root/graphs/sql/traffic_offense/req03.sql
blob: daebf4d63bd99ead225dac8dc1d7c1e6502d871c (plain)
1
2
3
4
5
6
7
8
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'
AND (
    description = 'SPEED_AND_TRAFFIC_VIOLATION'
    OR description = 'RECKLESS_AND_DANGEROUS_DRIVING'
)