Table: us_rugby_players
Columns: player
position
date_of_birth_age
caps
club_province

Question: What is the high cap total for a lock with the vicenza rangers?
SQL: SELECT MAX("caps") FROM us_rugby_players WHERE "position" = 'lock' AND "club_province" = 'vicenza rangers'

Question: When was nese malifa born?
SQL: SELECT "date_of_birth_age" FROM us_rugby_players WHERE "player" = 'nese malifa'

Question: What position for jj gagiano?
SQL: SELECT "position" FROM us_rugby_players WHERE "player" = 'jj gagiano'

Question: What club/province has 41 caps?
SQL: SELECT "club_province" FROM us_rugby_players WHERE "caps" = 41