-- Funkcie urcujuce poradie/RANK:
--	 ROW_NUMBER - ciselnik=jednoduche ocislovanie vratenych riadkov/zaznamov
--	 RANK		- poradie
--   DENSE_RANK - stlacene poradie
--   NTILE	    - nCasti
--   Spriemernene poradie - nie?!

USE Poliklinika;
GO

SELECT	ROW_NUMBER()OVER (ORDER BY poplatok) AS ciselnik,
		RANK()		OVER (ORDER BY poplatok) AS poradie,
		poplatok,
		DENSE_RANK()OVER (ORDER BY poplatok) AS stlcPor,
		NTILE(4)	OVER (ORDER BY poplatok) AS nCasti
	FROM  Navstevy
	WHERE poplatok IS NOT NULL
	  AND poplatok IN(300, 500)
	ORDER BY poplatok


--SELECT poplatok,
SELECT DISTINCT	poplatok,
		COUNT(poplatok) OVER(PARTITION BY poplatok) AS pocet,
	    SUM(poplatok)	OVER(PARTITION BY poplatok) AS suma,
	    AVG(poplatok)	OVER(PARTITION BY poplatok) AS priemer,
	    MAX(poplatok)	OVER(PARTITION BY poplatok) AS maxi
	FROM Navstevy
	WHERE poplatok IS NOT NULL
	  AND poplatok IN(300, 500)
	ORDER BY poplatok