Browse 554 attributed reviews, viewable separately for our classroom and online training

Details for smyndlo

smyndlo has participated in the following threads:

Added by smyndlo on 24 Nov 2019 at 13:54

SELECT  
        au.AuthorName Writer, --1st Table
        Doc.DoctorName Doctor, --2nd Table
        COUNT(Ep.EpisodeId) 'Num Of Episodes' --3rd Table
FROM tblAuthor AS Au
    INNER JOIN tblEpisode AS Ep
    ON Au.AuthorId = Ep.AuthorId
    INNER JOIN tblDoctor Doc
    ON Doc.DoctorId = Ep.DoctorId
GROUP BY Au.AuthorName, Doc.DoctorName
HAVING COUNT(Ep.EpisodeId) > 5
ORDER BY [Num Of Episodes] Desc