Table: ipl_player_stats
Columns: player
team
matches
overs
wickets
economy_rate
average
strike_rate
best_bowling

Question: How many matches were played that resulted in less than 59.1 overs and a 6.78 Economy rate?
SQL: SELECT SUM("matches") FROM ipl_player_stats WHERE "overs" < 59.1 AND "economy_rate" > 6.78

Question: What is the average of someone with more than 19 wickets and less than 16 matches?
SQL: SELECT AVG("average") FROM ipl_player_stats WHERE "wickets" > 19 AND "matches" < 16

Question: What were the total number of matches played when the Deccan Chargers had a strike rate of 15.5?
SQL: SELECT MAX("matches") FROM ipl_player_stats WHERE "team" = 'deccan chargers' AND "strike_rate" > 15.5