compile sql server online

Language: Layout:

-- your code goes here
create table Employee
(
 id int,
 name varchar(8),
deptId int)

create table Department
(
 id int,
 name varchar(8),
)

insert into Employee values(1, 'vishal', 1)
insert into Employee values(2, 'shallwe', 1)
insert into Employee values(3, 'we shall', 2)
insert into Employee values(4, 'pat ill', 2)
insert into Employee values(5, 'ill pat', 3)

insert into Department values(1, 'IT')
insert into Department values(2, 'Finance')
insert into Department values(3, 'HR')
insert into Department values(4, 'Admin')
insert into Department values(5, 'Network')

-- Emplyees and their departments
select e.Name as Employee, d.Name as Department from  Employee e 
Inner Join Department d on e.deptId = d.id

--Employees per department
select d.Name as Department, Count(e.Name) as Employees from  Employee e 
right Join Department d on e.deptId = d.id
group by d.Name, e.deptId

--Departments that dont have any employees 
select distinct d.Name as NoEmployeeHere from Department d 
  left outer join  Employee e on e.deptId = d.id
 where e.deptId is NULL

View schema
Execution time: 0.09 sec, rows selected: 12, rows affected: 10, absolute service time: 0.2 sec