SELECT addr,GROUP_CONCAT(username) AS userDetail,COUNT(*) AS totalUsers,SUM(age) AS sunAge,MAX(age) AS maxAge,MIN(age) AS minAge,AVG(age) AS avgAge?FROM user1?WHERE id >= 2?GROUP by addrORDER BY avgAge ? ? ? ??HAVING avgAge>17; ??
添加回答
舉報(bào)
0/150
提交
取消