After the year 2011, when the Canada - USA Rank was 46th, what was the League Rank?
CREATE TABLE table_name_54 (league VARCHAR, year VARCHAR, canada___usa_rank VARCHAR)
SELECT league AS Rank FROM table_name_54 WHERE year > 2011 AND canada___usa_rank = "46th"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_54 (league VARCHAR, year VARCHAR, canada___usa_rank VARCHAR) Question: After the year 2011, when the Canada - USA Rank was 46th, what was the League Rank? [/INST] SELECT league AS Rank FROM table_name_54 WHERE year > 2011 AND canada___usa_rank = "46th" </s>