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

Which type of crime has the most investigation complete cases?
SELECT type FROM greatermanchestercrime WHERE outcome = "Investigation complete; no suspect identified" GROUP BY type ORDER BY COUNT(*) DESC LIMIT 1
SELECT "type" FROM "greatermanchestercrime" WHERE "Investigation complete; no suspect identified" = "outcome" GROUP BY "type" ORDER BY COUNT(*) DESC NULLS LAST LIMIT 1