Table: rugby_squads_2007
Columns: player
position
date_of_birth_age
caps
club_province

Question: Which player has a Club/province of direito, less than 21 caps, and a Position of lock?
SQL: SELECT "player" FROM rugby_squads_2007 WHERE "club_province" = 'direito' AND "caps" < 21 AND "position" = 'lock'

Question: How many caps have a Position of prop, and a Player of rui cordeiro?
SQL: SELECT COUNT("caps") FROM rugby_squads_2007 WHERE "position" = 'prop' AND "player" = 'rui cordeiro'

Question: Which Club/province has a Player of david penalva?
SQL: SELECT "club_province" FROM rugby_squads_2007 WHERE "player" = 'david penalva'

Question: How many caps have a Date of Birth (Age) of 15 july 1981?
SQL: SELECT COUNT("caps") FROM rugby_squads_2007 WHERE "date_of_birth_age" = '15 july 1981'

Question: Which player has a Position of fly-half, and a Caps of 3?
SQL: SELECT "player" FROM rugby_squads_2007 WHERE "position" = 'fly-half' AND "caps" = 3