group by 语句里面不可以使用别名,例如
SELECT Customer,SUM(OrderPrice) FROM Orders GROUP BY Customer
但是不可以:
SELECT Customer AS cus , SUM(OrderPrice) FROM Orders GROUP BY cus