Browse 547 attributed reviews, viewable separately for our classroom and online training

Details for Phithel

Phithel has participated in the following threads:

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

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