[SQL] Particolare query con COUNT

[piero.mac]

dovresti raggruppare per type:

select type, count(id) as num_type
from news_article
group by type