|
44
95
|
|
0
0
0
0
0
|
|
4000
|
|
4000
78
1
SELECT s.Died AS WeekDied, COUNT(s.PersonID) AS DeathCount, ROUND(AVG(s.Age),0) AS AvgAge FROM (SELECT PersonID, Age, Died FROM persons p WHERE p.FirstRec<=44 AND p.Died>=44 AND p.Died <= 95 ORDER BY RAND() LIMIT 4000 ) AS s GROUP BY s.Died;
["254.5911242297"
"-19.6306151286" "0.6059118033" "-0.0071971435" "0.0000293009"] |