MySql COUNT datediff values in complex function -

i have sql query returns datediff of number of week

select   round(datediff((     select t.date actividad_newsletters t t.id_newsletter = t1.id_newsletter , t1.id_desc = 3 , (t.id_desc = 5 or t.id_desc = 7) , t.date > t1.date order t.date limit 1),     min(t1.date)   )/7, 0) weeks   actividad_newsletters t1   inner join newsletter t2 on t1.id_newsletter = t2.id  group id_newsletter having weeks not null 

and gets results:

0 0 0 0 0 1 1 1 1 1 1 2 2 3 3 3 3 3 3 3 3 3 3 3 . . . 117 117 118 119 119 

i want count same result like:

total week ----- ---- 5     0 6     1 2     2 11    3 .     . .     . .     . 2     117 1     118 2     119 

how should it? tried count(weeks) isn't working

thanks in advanced

try

select weeks, count(*) (select   round(datediff((     select t.date actividad_newsletters t t.id_newsletter = t1.id_newsletter , t1.id_desc = 3 , (t.id_desc = 5 or t.id_desc = 7) , t.date > t1.date order t.date limit 1),     min(t1.date)   )/7, 0) weeks   actividad_newsletters t1   inner join newsletter t2 on t1.id_newsletter = t2.id  group id_newsletter having weeks not null) t group weeks