MotaDan / PoliceData

0 stars 0 forks source link

Add locations with over 200 incidents to nicenames #2

Open MotaDan opened 8 years ago

MotaDan commented 8 years ago

SELECT COUNT(*), calls.*, nicenames.desc FROM calls LEFT JOIN nicenames ON calls.address LIKE '%' || nicenames.address || '%' WHERE nicenames.address IS NULL GROUP BY calls.address ORDER BY COUNT(*) DESC LIMIT 50;