GROUP BY

[-]

I can use subqueries to select from the following table to produce the
output:

Total 2004 2005 2006
----------------------------
10 2 4 4

foobar
---------------
DATE added_date

I was told that I can use GROUP BY (I think) instead.

I only managed to do the total which is

SELECT COUNT(*)
FROM foobar;

Please advice how I can get the sub count of the years.
Thank you.