CREATE TABLE greatermanchestercrime (crimeid TEXT, crimets TIME, location TEXT, lsoa TEXT, type TEXT, outcome TEXT)

Where is the most dangerous area?
SELECT location FROM greatermanchestercrime GROUP BY location ORDER BY COUNT(*) DESC LIMIT 1
SELECT "location" FROM "greatermanchestercrime" GROUP BY "location" ORDER BY COUNT(*) DESC NULLS LAST LIMIT 1