Can you tell me the highest Lost that has the Pool/Round of pool 2, and the Played smaller than 6?
CREATE TABLE table_name_43 (lost INTEGER, pool_round VARCHAR, played VARCHAR)
SELECT MAX(lost) FROM table_name_43 WHERE pool_round = "pool 2" AND played < 6
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_43 (lost INTEGER, pool_round VARCHAR, played VARCHAR) Question: Can you tell me the highest Lost that has the Pool/Round of pool 2, and the Played smaller than 6? [/INST] SELECT MAX(lost) FROM table_name_43 WHERE pool_round = "pool 2" AND played < 6 </s>