Table: vfl_soldiers
Columns: player
vfl_games
vfl_club_s
rank_held_at_time_of_death
date_of_death
location

Question: What vfl club(s) did players who played 23 cfl games play for?
SQL: SELECT "vfl_club_s" FROM vfl_soldiers WHERE "vfl_games" = 23

Question: What locations did sid o'neill play football?
SQL: SELECT "location" FROM vfl_soldiers WHERE "player" = 'Sid O''Neill'

Question: What vfl club(s) for players ranked sergeant, 8th brigade australian field artillery at time of death?
SQL: SELECT "vfl_club_s" FROM vfl_soldiers WHERE "rank_held_at_time_of_death" = 'Sergeant, 8th Brigade Australian Field Artillery'

Question: How many players named paddy rowan?
SQL: SELECT COUNT("rank_held_at_time_of_death") FROM vfl_soldiers WHERE "player" = 'Paddy Rowan'