sqlite获取数据的平均值

Question

执行下面的查询：

String selectQuery = "SELECT  max(score),name FROM " + TABLE_SCORE
                    +" group by name";

输出的值都是随机的，我需要它们从大到小排列。应该怎么实现？

Answer 1

select max(score) as nscore, name
from TABLE_XXX
group by name
order by nscore desc