summaryrefslogtreecommitdiff
path: root/graphs/sql/fast_and_murderous/req03.sql
blob: 4ae48368ae4d99c87b9dbda1cd90269fa892a6a5 (plain)
1
2
3
SELECT T.person_id,C.id,T.content,C.description FROM justice.testimonies AS T,justice.cases AS C
WHERE T.content LIKE '%Nexus N3%'
    AND C.description SIMILAR TO '%(speeding|speed|fast|reckless)%' AND T.case_id = C.id