I found this syntax in a online course. I do understand it. But how it works? I do not understand the HAVING COUNT (*) > 1.. Its mean count the rows of the table in my view.
SELECT M1.title, m1.director
FROM MOVIE as M1
INNER JOIN MOVIE as M2 ON M1.director = M2.director
GROUP BY m1.mID, m1.title, m1.director
HAVING COUNT(*) > 1
ORDER BY m1.director, m1.title;