CREATE TABLE table_name_18 (total NUMBER, rank VARCHAR2, county VARCHAR2)

Which Total has a Rank smaller than 3, and a County of cork?
SELECT MIN(total) FROM table_name_18 WHERE rank < 3 AND county = "cork"
SELECT MIN("total") FROM "table_name_18" WHERE "cork" = "county" AND "rank" < 3