oracle select语句 as,Oracle SQL – 帮助在Select语句中使用Case

CREATE TABLE student_totalexp2 nologging compress AS

SELECT /*+parallel(a,4)*/ DISTINCT a.member_sk,

CASE

WHEN b.end_date IS NULL THEN

SYSDATE - MIN(TO_DATE(b.start_date,'yyyymm'))

ELSE

(MAX(TO_DATE(b.end_date,'yyyymm')) - MIN(TO_DATE(b.start_date,'yyyymm')))

END as days_experience

FROM student_schools a

JOIN rdorwart.position_rd b ON a.member_sk = b.member_sk

WHERE days_experience < 730

GROUP BY a.member_sk;

SELECT COUNT(*)

FROM student_experience;

知道为什么我一直收到这个错误：错误报告：

SQL Error: ORA-00904: “DAYS_EXPERIENCE”: invalid identifier 00904. 00000 – “%s: invalid identifier”

*Cause:

*Action: