Table: cric_team_stats
Columns: year
matches
wins
losses
no_result
tied
success_rate

Question: What is the average number of ties for years with more than 19 wins?
SQL: SELECT AVG("tied") FROM cric_team_stats WHERE "wins" > 19

Question: What is the total number of losses for years with fewer than 9 wins?
SQL: SELECT COUNT("losses") FROM cric_team_stats WHERE "wins" < 9