What is the lowest Bronze, when Total is greater than 10, when Silver is greater than 0, and when Rank is "Total"?
CREATE TABLE table_name_83 (bronze INTEGER, rank VARCHAR, silver VARCHAR)
SELECT MIN(bronze) FROM table_name_83 WHERE "total" > 10 AND silver > 0 AND rank = "total"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_83 (bronze INTEGER, rank VARCHAR, silver VARCHAR) Question: What is the lowest Bronze, when Total is greater than 10, when Silver is greater than 0, and when Rank is "Total"? [/INST] SELECT MIN(bronze) FROM table_name_83 WHERE "total" > 10 AND silver > 0 AND rank = "total" </s>