SQL Aggregate Functions: COUNT, SUM, MIN, MAX, AVG
Classified in Computers
Written on in
English with a size of 12.36 KB
Aggregations
Consider the case of sports tournaments like cricket. Players' performances are analyzed based on their batting average, the maximum number of sixes hit, the lowest score in a tournament, etc.
In such scenarios, we perform aggregations to combine multiple values into a single value, i.e., individual scores into an average score.
Let's learn more about aggregations to perform insightful analysis using the following database.
Database: The database consists of a player_match_details table that stores information about players' details in a match, such as name, match, score, year, and the number of fours and sixes scored.