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

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 NULLS LAST LIMIT 1