question: Which Total has a Rank smaller than 3, and a County of cork?
answer: SELECT MIN(total) FROM table_name_18 WHERE rank < 3 AND county = "cork"
context: CREATE TABLE table_name_18 (total INTEGER, rank VARCHAR, county VARCHAR)