CREATE TABLE table_name_95 (silver NUMBER, nation VARCHAR2, total VARCHAR2, bronze VARCHAR2, gold VARCHAR2)

What is the highest number of silver medals that Ireland earned when they scored less than 3 bronze medals and earned 1 medal?
SELECT MAX(silver) FROM table_name_95 WHERE bronze < 3 AND gold < 1 AND total = 1 AND nation = "ireland"
SELECT MAX("silver") FROM "table_name_95" WHERE "bronze" < 3 AND "gold" < 1 AND "ireland" = "nation" AND "total" = 1