What is the most silver medals when the total is more than 2 medals, and with a rank of total, and the number of gold medals is greater than 44?
CREATE TABLE table_name_78 (silver INTEGER, gold VARCHAR, rank VARCHAR)
SELECT MAX(silver) FROM table_name_78 WHERE "total" > 2 AND rank = "total" AND gold > 44
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_78 (silver INTEGER, gold VARCHAR, rank VARCHAR) Question: What is the most silver medals when the total is more than 2 medals, and with a rank of total, and the number of gold medals is greater than 44? [/INST] SELECT MAX(silver) FROM table_name_78 WHERE "total" > 2 AND rank = "total" AND gold > 44 </s>