-- zad 4
-- 4.1
-- bez pivota
SELECT	YEAR(OrderDate) "Rok",
		SUM(IIF(MONTH(OrderDate) = 1, 1, 0)) [1],
		SUM(IIF(MONTH(OrderDate) = 2, 1, 0)) [2],
		SUM(IIF(MONTH(OrderDate) = 3, 1, 0)) [3],
		SUM(IIF(MONTH(OrderDate) = 4, 1, 0)) [4],
		SUM(IIF(MONTH(OrderDate) = 5, 1, 0)) [5],
		SUM(IIF(MONTH(OrderDate) = 6, 1, 0)) [6],
		SUM(IIF(MONTH(OrderDate) = 7, 1, 0)) [7],
		SUM(IIF(MONTH(OrderDate) = 8, 1, 0)) [8],
		SUM(IIF(MONTH(OrderDate) = 9, 1, 0)) [9],
		SUM(IIF(MONTH(OrderDate) = 10, 1, 0)) [10],
		SUM(IIF(MONTH(OrderDate) = 11, 1, 0)) [11],
		SUM(IIF(MONTH(OrderDate) = 12, 1, 0)) [12]
FROM	Sales.SalesOrderHeader
GROUP BY YEAR(OrderDate)
ORDER BY 1