Re: Return 0 for data with no matching values

[Peter Brawley]

For aggregation on year you'll need something like ...

select c.yr, count(d.dates)
from (select distinct year(date) yr from calendar) c
left join birthdates d on c.yr=year(d.dates)
group by c.yr;