Table: rugby_team_stats
Columns: player
span
start
tries
conv
pens
drop
lost
draw

Question: What is the player with a Span of 1998-2009?
SQL: SELECT "player" FROM rugby_team_stats WHERE "span" = '1998-2009'

Question: What draw has a Span of 1987-1999?
SQL: SELECT "draw" FROM rugby_team_stats WHERE "span" = '1987-1999'

Question: What player has a span of 1997-2009?
SQL: SELECT "player" FROM rugby_team_stats WHERE "span" = '1997-2009'

Question: What drop has a 0 conv and Tries of 6?
SQL: SELECT "drop" FROM rugby_team_stats WHERE "conv" = '0' AND "tries" = '6'

Question: What drop had a start of 40?
SQL: SELECT "drop" FROM rugby_team_stats WHERE "start" = '40'

Question: What drop had 0 pens, 1 draw, and 8 tries?
SQL: SELECT "drop" FROM rugby_team_stats WHERE "pens" = '0' AND "draw" = '1' AND "tries" = '8'