How many teams were promoted in the postseason in a tier above 2?
CREATE TABLE table_name_51 (pos VARCHAR, postseason VARCHAR, tier VARCHAR)
SELECT COUNT(pos) FROM table_name_51 WHERE postseason = "promoted" AND tier < 2
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_51 (pos VARCHAR, postseason VARCHAR, tier VARCHAR) Question: How many teams were promoted in the postseason in a tier above 2? [/INST] SELECT COUNT(pos) FROM table_name_51 WHERE postseason = "promoted" AND tier < 2 </s>