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

Which area do most of the crimes happen?
SELECT location FROM greatermanchestercrime GROUP BY location ORDER BY COUNT(*) DESC LIMIT 1
SELECT "location" FROM "greatermanchestercrime" GROUP BY "location" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY