Our training courses

Other training resources

Our training venues

Why we are different

Details for Anita

Anita has participated in the following threads:

Added by Anita on 27 Jun 2020 at 17:55

We can get the country name and no of event occured  without even using a subquery:

select distinct count([EventName]) as No_of_event,[CountryName] from [tblEvent] e
inner join [dbo].[tblCountry]  c on e.CountryID = c.CountryID
group by [CountryName]
having count([EventName]) >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 ...