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

Where was the last instance of a violent or sexual offense in Manchester?
SELECT location FROM greatermanchestercrime WHERE type = "Violence and sexual offences" ORDER BY crimets DESC LIMIT 1
SELECT "location" FROM "greatermanchestercrime" WHERE "Violence and sexual offences" = "type" ORDER BY "crimets" DESC FETCH FIRST 1 ROWS ONLY