--2017
insert into dbo.AbsolventiNaUP(Obor, OborId, PocetAbsolventu, Rok)
select
	obor,
	o.Id,
	avg(pocet_absolventu),
	2017
from
	(select Obor,
			pocet_absolventu
	from
	[dbo].[Kvalifikacni_str_absl_VS_201701]
	union all
	select Obor,
			pocet_absolventu
	from
		[dbo].[Kvalifikacni_str_absl_VS_201702]) as un
	left join dbo.Obory o on un.obor = o.nazev
	group by
	obor,
	o.id

--2016
insert into dbo.AbsolventiNaUP(Obor, OborId, PocetAbsolventu, Rok)
select
	obor,
	o.Id,
	avg(pocet_absolventu),
	2016
from
	(select Obor,
			pocet_absolventu
	from
		[dbo].[Kvalifikacni_str_absl_VS_201601]
	union all
	select Obor,
			pocet_absolventu
	from
		[dbo].[Kvalifikacni_str_absl_VS_201602]) as un
	left join dbo.Obory o on un.obor = o.nazev
	group by
	obor,
	o.id