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