select a.id,a.body,b.count(*) from news a, comments b where a.id = b.id(+) group by a.id,a.body