SELECT Blog.ID_blog, COUNT(*) FROM Blog, Commenti WHERE Commenti.ID_blog = Blog.ID_blog GROUP BY Blog.ID_blog;

ho vinto qualche cosa?