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

Details for walteragwe

walteragwe has participated in the following threads:

Added by walteragwe on 20 Jan 2021 at 03:43

SELECT  cm.[CompanionId],[CompanionName]
FROM [dbo].[tblCompanion] AS cm left outer JOIN [dbo].[tblEpisodeCompanion] AS Ec
ON cm.CompanionId = Ec.CompanionId
except
(SELECT  cm.[CompanionId],[CompanionName]
FROM [dbo].[tblCompanion] AS cm inner JOIN [dbo].[tblEpisodeCompanion] AS Ec 
ON cm.CompanionId = Ec.CompanionId);
GO

Added by walteragwe on 21 Jan 2021 at 02:47

SELECT [AuthorName], COUNT([EpisodeId]) AS [# OF EPISODES],
       MIN([EpisodeDate]) AS [Earliest epi Date],
       max([EpisodeDate]) as [latest epi Date]
FROM   [dbo].[tblAuthor] AS A INNER JOIN [dbo].[tblEpisode] AS E
       ON A.AuthorId = E.AuthorId
GROUP BY [AuthorName]
order by [# OF EPISODES] desc;
GO

Added by walteragwe on 21 Jan 2021 at 03:09

SELECT [AuthorName],[DoctorName],COUNT([EpisodeId]) AS [No of episodes]
FROM   [dbo].[tblAuthor]  A INNER JOIN [dbo].[tblEpisode] E
ON   A.AuthorId = E.AuthorId INNER JOIN [dbo].[tblDoctor] D
ON   E.DoctorId = D.DoctorId
GROUP BY [AuthorName],[DoctorName]
HAVING COUNT([EpisodeId]) > 5
ORDER BY [No of episodes] DESC;
GO