How many locations have #12 Michigan State as the big ten team?
CREATE TABLE table_24292 (
    "Date" text,
    "Time" text,
    "ACC Team" text,
    "Big Ten Team" text,
    "Location" text,
    "Television" text,
    "Attendance" real,
    "Winner" text,
    "Challenge Leader" text
)
SELECT COUNT("Location") FROM table_24292 WHERE "Big Ten Team" = '#12 Michigan State'
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 locations have #12 Michigan State as the big ten team? ### Input: CREATE TABLE table_24292 (
    "Date" text,
    "Time" text,
    "ACC Team" text,
    "Big Ten Team" text,
    "Location" text,
    "Television" text,
    "Attendance" real,
    "Winner" text,
    "Challenge Leader" text
) ### Response: SELECT COUNT("Location") FROM table_24292 WHERE "Big Ten Team" = '#12 Michigan State'