Sports channel displayed First 7 order lowest score table of INDIA, showing lowest runs made on 7th fall of wicket. How did they manage to do it?

1 Answer 1


The simple answer is "in a database". Assuming you've done the hard work of getting it all into the database in an appropriate form, it will be as simple as (in psuedo SQL):

SELECT * FROM wicket_falls WHERE wicket = 7 AND team = 'India' ORDER BY score

The other possibility is to use ESPN Cricinfo's "stats machine", but I'm rubbish at driving that so can't give you a like right now.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.