Our training courses

Other training resources

Our training venues

Why we are different

Details for Thomas

Thomas has participated in the following threads:

Added by ShukiMolk on 12 Apr 2020 at 23:38

Couldn't do it without using HAVING in the subquery :-(
Anyone has any ideas?

DISTINCT cntr.CountryName
FROM
    tblEvent evnt
    INNER JOIN tblCountry cntr
    ON evnt.CountryID = cntr.CountryID
WHERE evnt.CountryID IN
--countryID for countries that has more than 8 events
        (
        SELECT
        evnt.CountryID
        --,count(evnt.EventID) AS [Number of events]
        FROM
            tblEvent evnt
            INNER JOIN tblCountry cntr
            ON evnt.CountryID = cntr.CountryID
        GROUP BY
        evnt.CountryID,
        cntr.CountryName
        Having
        count(evnt.EventID) > 8
        )

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 ...