Table: rugby_squads_2007_3
Columns: player
position
date_of_birth_age
caps
club_province

Question: What is the club or province of Girvan Dempsey, who has 74 caps?
SQL: SELECT "club_province" FROM rugby_squads_2007_3 WHERE "caps" = 74 AND "player" = 'girvan dempsey'

Question: Which Ulster player has fewer than 49 caps and plays the wing position?
SQL: SELECT "player" FROM rugby_squads_2007_3 WHERE "caps" < 49 AND "position" = 'wing' AND "club_province" = 'ulster'

Question: Which player Munster from Munster is a fly-half?
SQL: SELECT "player" FROM rugby_squads_2007_3 WHERE "position" = 'fly-half' AND "club_province" = 'munster'