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

Which neighborhood/area has the highest burglary rate?
SELECT location FROM greatermanchestercrime WHERE type = "Burglary" GROUP BY location ORDER BY COUNT(*) DESC LIMIT 1
SELECT "location" FROM "greatermanchestercrime" WHERE "Burglary" = "type" GROUP BY "location" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY