Table: rugby_squads_2007_4
Columns: player
position
date_of_birth_age
caps
club_province

Question: Which player was a fly-half?
SQL: SELECT "player" FROM rugby_squads_2007_4 WHERE "position" = 'fly-half'

Question: What is the mean number of caps for Ryota Asano?
SQL: SELECT AVG("caps") FROM rugby_squads_2007_4 WHERE "player" = 'ryota asano'

Question: What is the mean number of caps for Ryota Asano?
SQL: SELECT AVG("caps") FROM rugby_squads_2007_4 WHERE "player" = 'ryota asano'