mysql> select bedrag, jaar, count(*) from subsidies GROUP BY jaar; +--------+------+----------+ | bedrag | jaar | count(*) | +--------+------+----------+ | 1239 | 1982 | 1 | | 1239 | 1985 | 2 | | 620 | 1986 | 2 | | 6197 | 1987 | 3 | | 1487 | 1988 | 4 | | 4958 | 1989 | 3 | | 2479 | 1990 | 5 | | 5578 | 1991 | 7 | | 1735 | 1992 | 4 | | 2479 | 1993 | 3 | | 2479 | 1994 | 8 | | 2355 | 1995 | 5 | | 3718 | 1996 | 8 | | 3099 | 1997 | 11 | | 12890 | 1998 | 11 | | 2231 | 1999 | 29 | | 3718 | 2000 | 159 | | 198315 | 2001 | 151 | | 90000 | 2002 | 174 | | 180000 | 2003 | 181 | | 180000 | 2004 | 207 | | 200000 | 2005 | 200 | | 600000 | 2006 | 222 | | 608751 | 2007 | 221 | | 618000 | 2008 | 142 | | 618000 | 2009 | 65 | +--------+------+----------+ 26 rows in set (0.41 sec)