MySQL 8 Cookbook

SUM

Find the sum of the salaries given to employees in each year and sort the results by salary. The YEAR() function returns the YEAR of the given date:

mysql> SELECT '2017-06-12', YEAR('2017-06-12');+------------+--------------------+| 2017-06-12 | YEAR('2017-06-12') |+------------+--------------------+| 2017-06-12 |               2017 |+------------+--------------------+1 row in set (0.00 sec)

mysql>  SELECT YEAR(from_date), SUM(salary) AS sum FROM salaries GROUP BY YEAR(from_date) ORDER BY sum DESC;+-----------------+-------------+| YEAR(from_date) | sum         |+-----------------+-------------+|            2000 | 17535667603 ||            2001 | 17507737308 ||            1999 | 17360258862 ||            1998 | 16220495471 ||            1997 | 15056011781 ||            1996 | 13888587737 ||            1995 | 12638817464 || 1994 | 11429450113 ...