-----------------------
--- Full Outer Join ---
-----------------------

select sum(Freight), count(*) from Orders
where EmployeeID = 1 and YEAR(OrderDate) = 1996

select sum(Freight), count(*) from Orders
where EmployeeID = 2 and YEAR(OrderDate) = 1997

select SUM(a.Freight) Emp1Freight, count(a.Freight) Emp1Count, SUM(b.Freight) Emp2Freight, count(b.Freight) Emp2Count
from
	(select * from Orders
	 where EmployeeID = 1 and YEAR(OrderDate) = 1996) a
full outer join
	(select * from Orders
	 where EmployeeID = 2 and YEAR(OrderDate) = 1997) b
on a.OrderID = b.OrderID

--OR 

select  Emp1Freight,  Emp1Count, Emp2Freight, Emp2Count
from
	(select SUM(Freight) Emp1Freight, count(Freight) Emp1Count from Orders
	 where EmployeeID = 1 and YEAR(OrderDate) = 1996) a,
	(select SUM(Freight) Emp2Freight, count(Freight) Emp2Count from Orders
	 where EmployeeID = 2 and YEAR(OrderDate) = 1997) b