USE Northwind

-- ćwiczenie 1

SELECT OrderID, SUM(UnitPrice*Quantity) FROM [ORDER Details] GROUP BY OrderID ORDER BY SUM(UnitPrice*Quantity)

SELECT top 10 OrderID, SUM(UnitPrice*Quantity) FROM [ORDER Details] GROUP BY OrderID ORDER BY SUM(UnitPrice*Quantity)

-- ćwiczenie 2

SELECT ProductID, SUM(Quantity) FROM [ORDER Details] WHERE ProductID < 3 GROUP BY ProductID

SELECT ProductID, SUM(Quantity) FROM [ORDER Details] GROUP BY ProductID

SELECT OrderID, SUM(Quantity*UnitPrice), SUM(Quantity) FROM [ORDER Details] GROUP BY OrderID HAVING SUM(Quantity) > 250

-- ćwiczenie 3

SELECT EmployeeID, COUNT(*) FROM Orders GROUP BY EmployeeID

SELECT ShipVia, SUM(Freight) AS "Oplata za przesylke" FROM Orders GROUP BY ShipVia

SELECT ShipVia, SUM(Freight) AS "Oplata za przesylke"
FROM Orders
WHERE  YEAR(ShippedDate)=1996 OR YEAR(ShippedDate)=1997
GROUP BY ShipVia

SELECT EmployeeID, YEAR(OrderDate) AS "Year", MONTH(OrderDate) AS "Month", COUNT(*) AS "number"
FROM Orders
GROUP BY EmployeeID, YEAR(OrderDate), MONTH(OrderDate)
ORDER BY EmployeeID, YEAR(OrderDate), MONTH(OrderDate)

SELECT CategoryID, MAX(UnitPrice) AS "Max", MIN(UnitPrice) AS "Min"
FROM Products
GROUP BY CategoryID