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

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 NULLS LAST LIMIT 1