def populationAge(year,country):

	date1=yearStart(year)

	date2=yearStart(year+1)

	query="""

		select date(?)-min_datum-1 as playing_years,count(pin)

			from (

				select ppt1.pin,min(ppt1.datum) as min_datum

					from players_performance_tournaments as ppt1

						join players_performance_tournaments as ppt2 on ppt1.pin=ppt2.pin

					where ppt2.datum>=date(?) and ppt2.datum<date(?) and ppt1.p_country_code=?

					group by ppt1.pin

			)

			group by playing_years"""

	res=cursor.execute(query,(date2,date1,date2,country))

	print("celé roky hraní\tpočet hráčů")

	for rec in res:

		print("\t".join([str(x) for x in rec]))

# populationAge(2017,"CZ")