SELECT z.name AS ziekte, COUNT(s.name) AS "aantal symptomen"
FROM symptomen s
INNER JOIN koppeling ON symptoom_id=s.id
INNER JOIN ziekte z ON ziekte_id=z.id
GROUP BY z.name
ORDER BY COUNT(s.name) DESC;