Which league had a playoffs result of a lost semifinal?
CREATE TABLE table_name_31 (league VARCHAR, playoffs VARCHAR)
SELECT league FROM table_name_31 WHERE playoffs = "lost semifinal"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_31 (league VARCHAR, playoffs VARCHAR) Question: Which league had a playoffs result of a lost semifinal? [/INST] SELECT league FROM table_name_31 WHERE playoffs = "lost semifinal" </s>