lab 2 zad 7

SELECT OrderID, ProductID, SUM(ROUND(UnitPrice*Quantity*(1-Discount),2))
AS Wartosc
FROM [ORDER Details]
WHERE OrderID <10264 AND OrderID > 10253 AND UnitPrice < 10
GROUP BY cube(OrderID, ProductID)
ORDER BY OrderID, ProductID

lab 2 zad 8

SELECT e.LastName, o.ShipCountry, COUNT(*)
FROM Employees e, Orders o
WHERE e.EmployeeID=o.EmployeeID
GROUP BY GROUPING sets((e.LastName, o.ShipCountry), (o.ShipCountry), (e.LastName))
ORDER BY E.LastName

lab 2 zad 9