CREATE TABLE table_name_12 (rank VARCHAR, opposition VARCHAR)

Which Rank has an Opposition of limerick?
SELECT rank FROM table_name_12 WHERE opposition = "limerick"
SELECT "rank" FROM "table_name_12" WHERE "limerick" = "opposition"