WHAT IS THE TOTAL WITH A NANQUAN OF 9.72, RANK BIGGER THAN 3, NANGUN SMALLER THAN 9.5?
CREATE TABLE table_name_50 (total INTEGER, nangun VARCHAR, nanquan VARCHAR, rank VARCHAR)
SELECT MIN(total) FROM table_name_50 WHERE nanquan = 9.72 AND rank > 3 AND nangun < 9.5
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_50 (total INTEGER, nangun VARCHAR, nanquan VARCHAR, rank VARCHAR) Question: WHAT IS THE TOTAL WITH A NANQUAN OF 9.72, RANK BIGGER THAN 3, NANGUN SMALLER THAN 9.5? [/INST] SELECT MIN(total) FROM table_name_50 WHERE nanquan = 9.72 AND rank > 3 AND nangun < 9.5 </s>