Table: rugby_stats_4
Columns: club
played
won
drawn
lost
points_for
points_against
tries_for
tries_against
try_bonus
losing_bonus
points

Question: How many clubs have a tries against count of 41?
SQL: SELECT COUNT("try_bonus") FROM rugby_stats_4 WHERE "tries_against" = '41'

Question: How many clubs have won 6 games?
SQL: SELECT COUNT("club") FROM rugby_stats_4 WHERE "won" = '6'

Question: How many clubs have a tries against count of 45 and a losing bonus of 4?
SQL: SELECT COUNT("tries_for") FROM rugby_stats_4 WHERE "tries_against" = '45' AND "losing_bonus" = '4'

Question: What club has a tries for count of 19?
SQL: SELECT "club" FROM rugby_stats_4 WHERE "tries_for" = '19'

Question: How many clubs have tries for count of 50?
SQL: SELECT COUNT("played") FROM rugby_stats_4 WHERE "tries_for" = '50'

Question: What's the number of drawn games for the club with a tries for count of 76?
SQL: SELECT "drawn" FROM rugby_stats_4 WHERE "tries_for" = '76'