SQL行转列问题求教

t1表结构如下：

提示报错为t2中SELECT语句,不明白问题出在何处，还望坛友不吝赐教

with t1 as (
    SELECT
        入库日期,入库级别,
        ROUND(sum((重量/1000)),3) as "重量1"
    FROM jl_ccp
    WHERE 入库类别='正常入库' AND 入库日期>="2023-09-01"
    GROUP BY 入库日期,入库级别 
)
t2 as(
    SELECT 入库日期,
        sum(CASE WHEN 入库级别='SE2GA' THEN '重量1' ELSE 0 END) 'SE2GA',
        sum(CASE WHEN 入库级别='SEGA' THEN '重量1' ELSE 0 END) 'SEGA',
        sum(CASE WHEN 入库级别='SHGA' THEN '重量1' ELSE 0 END) 'SHGA'
FROM t1
GROUP BY 入库日期
)
-- SELECT * FROM t1 ;
SELECT * FROM t2;