problema con date in sql server

[optime]

select count(*), mese
from tabella
group by mese

adattala