CREATE TABLE table_name_90 (club_province VARCHAR2, caps VARCHAR2)

Which club has 1 cap?
SELECT club_province FROM table_name_90 WHERE caps = 1
SELECT "club_province" FROM "table_name_90" WHERE "caps" = 1