CREATE TABLE table_name_64 (county VARCHAR, opposition VARCHAR)

Which County has an Opposition of offaly?
SELECT county FROM table_name_64 WHERE opposition = "offaly"
SELECT "county" FROM "table_name_64" WHERE "offaly" = "opposition"