[sql]SELECT p.lastname, p.firstname, SUM(r.value) AS Total, MAX( r.value) AS Maximum, p.birthdate
FROM player p INNER JOIN Resuls r ON p.id_player = r.id_player
GROUP BY p.lastname, p.firstname, p.birthdate , p.id_player ORDER BY Total DESC, Maximum DESC, birthdate ASC[/sql]