How many airlines have the star alliance and are in brazil?
CREATE TABLE table_name_13 (rank VARCHAR, alliance VARCHAR, country VARCHAR)
SELECT COUNT(rank) FROM table_name_13 WHERE alliance = "star alliance" AND country = "brazil"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_13 (rank VARCHAR, alliance VARCHAR, country VARCHAR) Question: How many airlines have the star alliance and are in brazil? [/INST] SELECT COUNT(rank) FROM table_name_13 WHERE alliance = "star alliance" AND country = "brazil" </s>