sql-server - SQL Server "Invalid column name"错误 |新手

Question

我正忙于自学 SQL Server，使用 SQL Server Management Studio。这是产生错误的代码:

SELECT SalesPersonID, COUNT(SalesOrderID), YEAR(OrderDate) AS SalesYear
FROM Sales.SalesOrderHeader
GROUP BY SalesYear;

为什么会抛出这个错误？

Invalid column name 'SalesYear'.

Answer 1

Invalid column name 'SalesYear'.

此列不会出现在表 SalesOrderHeader 中
SELECT SalesPersonID, COUNT(SalesOrderID), YEAR(OrderDate) AS SalesYear
FROM Sales.SalesOrderHeader GROUP BY YEAR(OrderDate)