:Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column

解决方法就是Sql order by 和 group BY一起使用时需要注意,.ORDER BY 排序字段必须包含在聚合函数或 GROUP BY 子句中

其中聚合函数是：avg count max min sum