# HG changeset patch
# User Laman
# Date 2018-03-27 13:46:11
# Node ID 8d852e1a7103201f9c218a5661f9a27c2faec94a
# Parent  9c927dc379bc2bf846d41d2a7b502c08b4087b3d

tournamentAttendance query

diff --git a/queries.py b/queries.py
--- a/queries.py
+++ b/queries.py
@@ -96,8 +96,15 @@ def populationAge(year,country):
 		print("\t".join([str(x) for x in rec]))
 
 
-def tournamentAttendance():
-	pass
+def tournamentAttendance(year):
+	date1=yearStart(year)
+	date2=yearStart(year+1)
+	query="""select country_code,sum(player_count) from tournaments where datum>=date(?) and datum<date(?) group by country_code"""
+
+	res=cursor.execute(query,(date1,date2))
+	print("kód země\tpočet hráčů na turnajích")
+	for rec in res:
+		print("\t".join([str(x) for x in rec]))
 
 
 # playerYear("Kotowski Jaroslav",2017)
@@ -105,3 +112,4 @@ def tournamentAttendance():
 # timeRank(2017,"CZ")
 # populationStrength(2017,"CZ")
 # populationAge(2017,"CZ")
+# tournamentAttendance(2010)