Our training courses

Other training resources

Our training venues

Why we are different

Details for Phithel

Phithel has participated in the following threads:

Added by najilevi on 26 Jul 2018 at 09:08

Hi,

 I tried to solve exercise B with the WAR and the DEATH but haven't succeeded207 yet.  Can someone can help me and write the correct answer?

This is what I wrote:

select *
from tblEvent
where CategoryID = 5 or CategoryID = 6 and (EventDetails not like ('%war%death%')

Thanks

Nadav

Added by odkao on 29 Jun 2018 at 14:17

Hello.

I'm having trouble getting this exercise done.

Is there anywhere i can get the solution? 

Added by grao on 07 Nov 2017 at 01:34

I am not getting any results. Is this the right code?

use doctorwho

Select companionname
from tblCompanion as c
left outer join tblEpisodeCompanion as e
on c.CompanionId=e.EpisodeCompanionId
where e.EpisodeCompanionId =null

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