diff --git a/queries.py b/queries.py --- a/queries.py +++ b/queries.py @@ -76,8 +76,24 @@ def populationStrength(year,country): print("\t".join([str(x) for x in rec])) -def populationAge(): - pass +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