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

Which Lower Layer Output Area do most of the crimes happen?
SELECT lsoa FROM greatermanchestercrime GROUP BY lsoa ORDER BY COUNT(*) DESC LIMIT 1
SELECT "lsoa" FROM "greatermanchestercrime" GROUP BY "lsoa" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY