mysql count as 中文，order by 中文，结果不正确

Question

第一条sql：
SELECT count(*) as "数量", user_id FROM order where status = 1 GROUP BY user_id ORDER BY "数量" desc ;

第二条sql：
SELECT count(*) as a, user_id FROM order where status = 1 GROUP BY user_id ORDER BY a desc ;

这两条sql 结果不一样，并且第一条sql结果不正确，这是为什么

Answer 1

排序别名不要加引号

Answer 2

把引号去掉就OK了