Database

SELECT Sales.ProductId,
   SUM(Sales.SalesUnit) AS TotalSale,
   SUM(CASE Staff.Team = 1 THEN Sales.SalesUnit ELSE 0 END AS Sale_of_team1,
   SUM(CASE Staff.Team = 2 THEN Sales.SalesUnit ELSE 0 END AS Sale_of_team2,
   SUM(CASE Staff.Team = 3 THEN Sales.SalesUnit ELSE 0 END AS Sale_of_team3
FROM Sales
INNER JOIN Staff
ON Staff.StaffId = Sales.StaffId
GROUP BY Sales.ProductId

SELECT Product.ProductId,
   (SELECT SUM(SalesUnit) FROM Sales) AS TotalSale,
   (SELECT SUM(SalesUnit) FROM Sales
       INNER JOIN Staff
       ON Staff.StaffId = Sales.StaffId
       AND Staff.Team = 1
       WHERE Sales.ProductId = Product.ProductId) AS Sale_of_team1,
   (SELECT SUM(SalesUnit) FROM Sales
       INNER JOIN Staff
       ON Staff.StaffId = Sales.StaffId
       AND Staff.Team = 2
       WHERE Sales.ProductId = Product.ProductId) AS Sale_of_team2,
   (SELECT SUM(SalesUnit) FROM Sales
       INNER JOIN Staff
       ON Staff.StaffId = Sales.StaffId
       AND Staff.Team = 3
       WHERE Sales.ProductId = Product.ProductId) AS Sale_of_team3
FROM Products

SELECT * FROM MyTable<br />
WHERE Job IS NOT NULL<br />
OR Name NOT IN (SELECT NAME FROM MyTable WHERE Job IS NOT NULL)