分组排序的功能实现
cat */* | awk -F'|' '{++S[$3];C[$3]+=$4} END{for(a in S) print S[a],"\t",C[a],"\t",a}' | sort -nr
SELECT COUNT(money) AS totalCost FROM user_consume GROUP BY username ORDER BY num DESC