Scenario: Assume that a table has data from a cricket team with details such as ID , Name, Role , Age ,City, Average. SO you need to calculate how many bowlers you have selected from the table, total no. of players selected and their average age.
Similarly, if batsman age or count is required then simply change the value of Contains to "Batsman" from the above code.
Happy Coding!
No comments:
Post a Comment