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

How many crimes has been conducted?
SELECT COUNT(*) FROM greatermanchestercrime
SELECT COUNT(*) FROM "greatermanchestercrime"