GROUP BY e ordinare in base ad AVG DESC

[oly1982]

NON CI POSSO CREDERE!!!

$query = "SELECT SUBSTRING_INDEX(country, ' - ', 1), COUNT(id_tempo), AVG(timing), MIN(timing) FROM tempi_sim GROUP BY SUBSTRING_INDEX(country, ' - ', 1) ORDER BY AVG(timing) ASC";
$result = mysql_query($query) or die(mysql_error());
while($rows = mysql_fetch_row($result))
    {
    echo $rows[0].' - '.$rows[1].' - '.$rows[2].' - '.$rows[3];
    echo '
';
    } 

Mi sento fiero di me stesso!!!