|
44
95
|
|
0
0
0
0
0
|
|
4000
|
|
4000
78
0
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;
["769.8175996782"
"-51.4990107502" "1.3233730486" "-0.0141522602" "0.0000538077"] |