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

Details for linjom

linjom has participated in the following threads:

Added by bhilarev on 25 Oct 2017 at 07:14

I just get only four rows ,

Select
x.AuthorName,y.EpisodeNumber,y.Title,y.EpisodeDate
From Author As x
INNER JOIN Episode As y
ON x.AuthorId = y.AuthorId
Where Title Like '%Daleks%';

Is this query correct?

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 linjom on 17 Apr 2018 at 13:17

I could solve till the second last requirement. The final one seems tough .... can anyone help with the trick?

Added by linjom on 23 Apr 2018 at 07:33

I am getting different result.. 

NULL    459
18th Century    4
19th Century    14
20th Century    396
21st Century    45

for both rollup and cube.. is this right? Final total same as site.