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

Which type of crime has the highest rate of 'Investigation complete'?
SELECT type FROM greatermanchestercrime WHERE outcome LIKE "%Investigation complete%" GROUP BY type ORDER BY COUNT(*) DESC LIMIT 1
SELECT "type" FROM "greatermanchestercrime" WHERE "outcome" LIKE "%Investigation complete%" GROUP BY "type" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY