Sample Widget - Birth Month

The SQL Query used in this widget is:
select BD =
   case MONTH(BIRTH_DATE)

WHEN '1' THEN 'January'

WHEN '2' THEN 'February'

WHEN '3' THEN 'March'

WHEN '4' THEN 'April'

WHEN '5' THEN 'May'

WHEN '6' THEN 'June'

WHEN '7' THEN 'July'

WHEN '8' THEN 'August'

WHEN '9' THEN 'September'

WHEN '10' THEN 'October'

WHEN '11' THEN 'November'

WHEN '12' THEN 'December'

end, count(*) as TOTAL

 
from REV_PERSON
where BIRTH_DATE is not null
GROUP BY MONTH(BIRTH_DATE)
ORDER BY MONTH(BIRTH_DATE)