I am trying to return the number of people registered in a particular month, but would like also to return zeros in months that are not in the database. 

The following query returns number of people registered in months in the database:

```
select 
    extract(year from "DATECREATED") as YEAR, 
    extract(month from "DATECREATED") as mon,
    count("USERID") as Total
from 
    TBLG2O_USEROFO 
where 
    extract(year from "DATECREATED") = '2014'
group by 
    extract(year from "DATECREATED"), 
    extract(month from "DATECREATED")
order by 
    1, 2

```