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

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 FETCH FIRST 1 ROWS ONLY