Q&A for users and developers of the Cardano cryptocurrency ecosystem
SELECT ph.Name, Count(*) From ReviewTaskResults r LEFT JOIN ReviewTaskResultTypes ph ON ph.Id = r.ReviewTaskResultTypeId Group by ph.Name