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

Which type of crime happen the most in Salford?
SELECT type FROM greatermanchestercrime WHERE lsoa LIKE "%Salford%" GROUP BY type ORDER BY COUNT(*) DESC LIMIT 1
SELECT "type" FROM "greatermanchestercrime" WHERE "lsoa" LIKE "%Salford%" GROUP BY "type" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY