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

How many crimes were classified as 'Drugs'?
SELECT COUNT(*) FROM greatermanchestercrime WHERE type LIKE "%Drug%"
SELECT COUNT(*) FROM "greatermanchestercrime" WHERE "type" LIKE "%Drug%"