Masters of the Chase

Hard · IPL cricket · Tables: matches, deliveries

Calculate chasing success for teams that chased in at least 20 completed matches. Derive the first-innings batting team from deliveries, infer the chasing team from matches, and return chasing_team, chases, successful_chases, and success_pct rounded to one decimal. Show the ten best rates.

More SQL practice problems