What is the highest number of silver medals that Ireland earned when they scored less than 3 bronze medals and earned 1 medal?
CREATE TABLE table_name_95 (silver INTEGER, nation VARCHAR, total VARCHAR, bronze VARCHAR, gold VARCHAR)
SELECT MAX(silver) FROM table_name_95 WHERE bronze < 3 AND gold < 1 AND total = 1 AND nation = "ireland"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_95 (silver INTEGER, nation VARCHAR, total VARCHAR, bronze VARCHAR, gold VARCHAR) Question: What is the highest number of silver medals that Ireland earned when they scored less than 3 bronze medals and earned 1 medal? [/INST] SELECT MAX(silver) FROM table_name_95 WHERE bronze < 3 AND gold < 1 AND total = 1 AND nation = "ireland" </s>