Anonymní profil P – Programujte.com

http://stackoverflow.com/questions/7340757/c-sharp-list-removing-items-while-looping-iterating

SELECT
	  poz.nazev
	, SUM(CASE WHEN zam.mzda >= poz.maximalni_mzda THEN 1 ELSE 0 END) AS pocet_maximalni_mzda
	, SUM(CASE WHEN zam.mzda <= poz.minimalni_mzda THEN 1 ELSE 0 END) AS pocet_minimalni_mzda
	, COUNT(*) AS pocet_celkem
FROM
	zamestnanci zam
	INNER JOIN prac_pozice poz ON poz.id = zam.pozice_id
GROUP BY
	poz.nazev