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

What are the most likely outcome of the police investigation if the crime happen on 'street'?
SELECT outcome FROM greatermanchestercrime WHERE location LIKE "%Street%" GROUP BY outcome ORDER BY COUNT(*) DESC LIMIT 1
SELECT "outcome" FROM "greatermanchestercrime" WHERE "location" LIKE "%Street%" GROUP BY "outcome" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY