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

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 NULLS LAST LIMIT 1