Our training courses

Other training resources

Our training venues

Why we are different

Details for Wise Owl 2

Wise Owl 2 has participated in the following threads:

Added by Wise Owl 2 on 08 Nov 2021 at 13:23

with aut as (
select  count(title) as [Number of episodes wrote],AuthorId from tblEpisode
group by AuthorId
)
select a.Authorname,b.[Number of episodes wrote],max(c.episodeDate) as [Latest Episode Date],min(c.episodedate) as [Earliest Episode Date] from tblAuthor a
inner join aut b on a.AuthorId=b.authorId
inner join tblEpisode c on a.AuthorId=c.AuthorId
group by AuthorName,[Number of episodes wrote]
order by [Number of episodes wrote] 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 ...