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

Where is the safest area?
SELECT location FROM greatermanchestercrime GROUP BY location ORDER BY COUNT(*) LIMIT 1
SELECT "location" FROM "greatermanchestercrime" GROUP BY "location" ORDER BY COUNT(*) FETCH FIRST 1 ROWS ONLY