SELECT cname, COUNT(snr) AS antal_tilmeldte
FROM Course LEFT JOIN Signup
ON Course.cid=Signup.cid
GROUP BY cname
ORDER BY antal_tilmeldte
DESC LIMIT 2;