SELECT p."id", p."passageTitle", COUNT(q."PassageId") as numQuestions
FROM "Passages" as p
LEFT  JOIN "Questions" as q
ON p.id=q."PassageId"
WHERE q."status" = 'active'
GROUP BY p.id
ORDER BY p.id ASC