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

Where is the place with the largest number of sexual offenses crime events?
SELECT location FROM greatermanchestercrime WHERE type = "Violence and sexual offences" GROUP BY location ORDER BY COUNT(*) DESC LIMIT 1
SELECT "location" FROM "greatermanchestercrime" WHERE "Violence and sexual offences" = "type" GROUP BY "location" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY