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

How many crimes are still 'Under investigation' to date?
SELECT COUNT(*) FROM greatermanchestercrime WHERE outcome LIKE "%Under investigation%"
SELECT COUNT(*) FROM "greatermanchestercrime" WHERE "outcome" LIKE "%Under investigation%"