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'
)
|