Select Dept.DeptNo,Dept.DName,Dept.Loc,Count(*),Avg(Sal)
From Dept,Emp
Where Dept.DeptNO=Emp.DeptNO
Group By Dept.DeptNo,Dept.DName,Dept.Loc
Select Dept.*,Nvl(t.Nums,0),Nvl(t.AvgSal,0)
From Dept,
(Select DeptNo,Count(*) Nums,Avg(Sal) AvgSal From Emp
Group By DeptNO ) t
Where Dept.DeptNo=*t.DeptNo
Select Dept.*,Nvl(t.Nums,0),Nvl(t.AvgSal,0)
From Dept,
(Select DeptNo,Count(*) Nums,Avg(Sal) AvgSal From Emp
Group By DeptNO ) t
Where Dept.DeptNo=t.DeptNo(+)
Select Dept.DeptNo,Dept.DName,Dept.Loc,Count(*),Avg(Sal)
From Dept,Emp
Where Dept.DeptNO==Emp.DeptNO
Group By Dept.DeptNo,Dept.DName,Dept.Loc
Select Dept.DeptNo,Dept.DName,Dept.Loc,Count(*),Avg(Sal)
From Dept,Emp
Where Dept.DeptNO=Emp.DeptNO
Group By Dept.DeptNo,Dept.DName,Dept.Loc
Select Dept.*,Nvl(t.Nums,0),Nvl(t.AvgSal,0)
From Dept,
(Select DeptNo,Count(*) Nums,Avg(Sal) AvgSal From Emp
Group By DeptNO ) t
Where Dept.DeptNo=*t.DeptNo
Select Dept.*,Nvl(t.Nums,0),Nvl(t.AvgSal,0)
From Dept,
(Select DeptNo,Count(*) Nums,Avg(Sal) AvgSal From Emp
Group By DeptNO ) t
Where Dept.DeptNo=t.DeptNo(+)
Select Dept.DeptNo,Dept.DName,Dept.Loc,Count(*),Avg(Sal)
From Dept,Emp
Where Dept.DeptNO==Emp.DeptNO
Group By Dept.DeptNo,Dept.DName,Dept.Loc
