What Canadian Championship had CONCACAF Champions League of semifinals?
CREATE TABLE table_name_6 (canadian_championship VARCHAR, concacaf_champions_league VARCHAR)
SELECT canadian_championship FROM table_name_6 WHERE concacaf_champions_league = "semifinals"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_6 (canadian_championship VARCHAR, concacaf_champions_league VARCHAR) Question: What Canadian Championship had CONCACAF Champions League of semifinals? [/INST] SELECT canadian_championship FROM table_name_6 WHERE concacaf_champions_league = "semifinals" </s>