What is the highest total number of finals a club with more than 2 runners-up and fewer than 1 winner went to?
CREATE TABLE table_name_56 (total_finals INTEGER, runners_up VARCHAR, winners VARCHAR)
SELECT MAX(total_finals) FROM table_name_56 WHERE runners_up > 2 AND winners < 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_56 (total_finals INTEGER, runners_up VARCHAR, winners VARCHAR) Question: What is the highest total number of finals a club with more than 2 runners-up and fewer than 1 winner went to? [/INST] SELECT MAX(total_finals) FROM table_name_56 WHERE runners_up > 2 AND winners < 1 </s>