Numero commenti al post

[neida]

SELECT p.titolo, p.testo, COUNT(*) AS num_commenti
FROM POST p, COMMENTI c
WHERE p.id = c.idpost
GROUP BY p.id