CREATE TABLE table_name_6 (week INT, transition VARCHAR)

What was the first week that had a transition with Pat Mccready?
SELECT MIN(week) FROM table_name_6 WHERE transition = "pat mccready"
SELECT MIN("week") FROM "table_name_6" WHERE "pat mccready" = "transition"