SUM « Aggregate Functions « SQL / MySQL






  1. SQL / MySQL
  2. Aggregate Functions
  3. SUM
1.SUM() function returns the sum of the expression.
2.SUM() the commission
3.Sum by group
4.Some aggregate functions can still produce NULL as a result.
5.What is the total amount of mail traffic and the average size of each message?
6.What is the total population of the United States?
7.Summaries and NULL Values
8.To determine how many drivers were on the road and how many miles were driven each day
9.Finding Smallest or Largest Summary Values




10.The number of votes for each programming language is determined with SUM(IF(...))
11.To compute the runner's average speed at the end of each stage