Inner Join With Count And Case

Here in this blog, I have discussed about inner join with count and case tutorial.

In this code I am showing how to count records in more than one table and how to use case for printing message.

select COUNT( * ) as 'Num of Role', Types = (
    case when UserRole.Id = 1 then 'Created By Admin'
    when UserRole.Id = 8 then 'Created By Creator'
    end) from Model inner join dbo.[User] on Model.UserId = [User].Id
inner join UserRole on dbo.[User].UserRoleId = dbo.[UserRole].Id Group By UserRole.Id

Output