What was the first week that had a transition with Pat Mccready?
CREATE TABLE table_name_6 (week INTEGER, transition VARCHAR)
SELECT MIN(week) FROM table_name_6 WHERE transition = "pat mccready"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_6 (week INTEGER, transition VARCHAR) Question: What was the first week that had a transition with Pat Mccready? [/INST] SELECT MIN(week) FROM table_name_6 WHERE transition = "pat mccready" </s>