Our training courses

Other training resources

Our training venues

Why we are different

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

Head office

Kingsmoor House

Railway Street

GLOSSOP

SK13 2AA

London

Landmark Offices

99 Bishopsgate

LONDON

EC2M 3XD

Manchester

Holiday Inn

25 Aytoun Street

MANCHESTER

M1 3AE

© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.

End of small page here
Please be aware that our website uses cookies!
I'm OK with this Tell me more ...