Which nation has a heat of 4, and is ranked 8?
CREATE TABLE table_name_13 (nation VARCHAR, heat VARCHAR, rank VARCHAR)
SELECT nation FROM table_name_13 WHERE heat = 4 AND rank = 8
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_13 (nation VARCHAR, heat VARCHAR, rank VARCHAR) Question: Which nation has a heat of 4, and is ranked 8? [/INST] SELECT nation FROM table_name_13 WHERE heat = 4 AND rank = 8 </s>