user: ### NOW ANSWER:
Question: What was the first week that had a transition with Pat McCready?
Columns: ['Month', 'Week', 'Overall', 'Offensive', 'Defensive', 'Transition', 'Rookie']
Types: ['text', 'real', 'text', 'text', 'text', 'text', 'text']
Sample row: ['December', 1.0, 'Jason Wulder', 'Jason Wulder', 'Gord Nash', 'Josh Sims', 'Dane Dobbie']
SQL:

assistant: SELECT MIN("Week") FROM "Table" WHERE "Transition" = 'Pat McCready';