SELECT state, 
sum(IF(month(identifier)=1,1,0)) as 'Jan',
sum(IF(month(identifier)=2,1,0)) as 'Feb',
sum(IF(month(identifier)=3,1,0)) as 'Mar',
count(*) as TOTAL
from contacts
WHERE state != ''
GROUP BY state;

##</code><code>##

+----------+-----+-----+----+-------+
| state    | Jan | Feb | Mar| Total |
+----------+-----+-----+----+-------+
| NY       |  10 | 12  | 11 |    33 |
| IL       |  15 | 14  | 15 |    44 |
| TX       |  25 | 20  | 22 |    67 |
+----------+-----+-----+----+-------+


##</code><code>##

 _  _ _  _  
(_|| | |(_|><
 _|