SQL：无法绑定由多个部分组成的标识符（select子句）

无法绑定由多个部分组成的标识符怎么回事

SQL 语句如下：

SELECT * FROM #temp
SELECT ageRange,sex, AVG(A) FROM(
SELECT
CASE
WHEN Age < 35 THEN ‘<35’
WHEN Age >= 35 AND Age <= 39 THEN ‘35-39’
WHEN Age >= 40 AND Age <= 45 THEN ‘40-45’
WHEN Age >45 AND Age <= 49 THEN ‘45-49’
WHEN Age >= 50 and Age<= 54 THEN ‘50-54’
WHEN Age >= 55 and Age<= 59 THEN ‘50-59’
WHEN Age >= 60 THEN ‘>=60’
END as ageRange,
SexId as sex
from #temp
) a
GROUP BY ageRange,sex;

执行语句时，报错：无法绑定由多个部分组成的标识符（或该列名无效）
原因：里层的select子句没有返回BMI，所以外层select语句里的AVG(A)就找不到A这个列

修改如下：
SELECT * FROM #temp
SELECT ageRange,sex, AVG(A) FROM(
SELECT
CASE
WHEN Age < 35 THEN ‘<35’
WHEN Age >= 35 AND Age <= 39 THEN ‘35-39’
WHEN Age >= 40 AND Age <= 45 THEN ‘40-45’
WHEN Age >45 AND Age <= 49 THEN ‘45-49’
WHEN Age >= 50 and Age<= 54 THEN ‘50-54’
WHEN Age >= 55 and Age<= 59 THEN ‘50-59’
WHEN Age >= 60 THEN ‘>=60’
END as ageRange,
SexId as sex,A
from #temp
) a
GROUP BY ageRange,sex;

问题解决！