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

Which type of crime has the most prosecution cases?
SELECT type FROM greatermanchestercrime WHERE outcome = "Awaiting court outcome" GROUP BY type ORDER BY COUNT(*) DESC LIMIT 1
SELECT "type" FROM "greatermanchestercrime" WHERE "Awaiting court outcome" = "outcome" GROUP BY "type" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY