Which conference joined in 1954 with a beavers mascot?
CREATE TABLE table_name_40 (conference_joined VARCHAR, year_joined VARCHAR, mascot VARCHAR)
SELECT conference_joined FROM table_name_40 WHERE year_joined = 1954 AND mascot = "beavers"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_40 (conference_joined VARCHAR, year_joined VARCHAR, mascot VARCHAR) Question: Which conference joined in 1954 with a beavers mascot? [/INST] SELECT conference_joined FROM table_name_40 WHERE year_joined = 1954 AND mascot = "beavers" </s>