[volby] ukazka vypoctu tesnych senatnich voleb

[kokes]

with hlasy as (
	SELECT
		datum,
		obvod,
		jmeno || ' ' || prijmeni AS jmeno,
		hlasy_k2,
		rank() over(partition by datum, obvod order by hlasy_k2 desc) as poradi
	FROM
		volby.senat_kandidati
	WHERE hlasy_k2 > 0
), naskoky as (
	select
	*, hlasy_k2 - lag(hlasy_k2) over(partition by datum, obvod order by poradi desc) as naskok
	from hlasy
)

select * from naskoky where naskok is not null order by naskok asc