How many crimes are still 'Under investigation' to date?
CREATE TABLE greatermanchestercrime (
    crimeid text,
    crimets time,
    location text,
    lsoa text,
    type text,
    outcome text
)
SELECT COUNT(*) FROM greatermanchestercrime WHERE outcome LIKE "%Under investigation%"
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: How many crimes are still 'Under investigation' to date? ### Input: CREATE TABLE greatermanchestercrime (
    crimeid text,
    crimets time,
    location text,
    lsoa text,
    type text,
    outcome text
) ### Response: SELECT COUNT(*) FROM greatermanchestercrime WHERE outcome LIKE "%Under investigation%"