-- SQL Folien Lösungsvarianten

SELECT *
FROM exemplar,
(SELECT HID, COUNT(*) AS anzahl
FROM exemplar
GROUP BY HID HAVING COUNT(*) > 5) AS blub
WHERE exemplar.hid = blub.hid

SELECT *
FROM
(SELECT EID, HID, COUNT(*) OVER (PARTITION BY HID) AS anzahl
FROM exemplar) AS blub
WHERE blub.anzahl > 5