关于SQL语句的注意事项
group by 语句里面不可以使用别名,例如

SELECT Customer,SUM(OrderPrice) FROM Orders GROUP BY Customer

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

SELECT Customer,SUM(OrderPrice) FROM Orders GROUP BY Customer

但是不可以:
SELECT Customer AS cus , SUM(OrderPrice) FROM Orders GROUP BY cus