POSTGRESQL 上的错误关系不存在 SQL WITH

Question

我收到错误：关系“case_avg”在我的 sql 请求中不存在

    with case_avg AS
                (select
                               avg(vv.total_vcpu) as avgvcpu,
                               avg(vv.total_vram) as avgvram,
                               avg(vv.total_hdd) as avghdd,
                               pod,
                               report_date
                from common.vmware_vm vv
                group by pod,report_date)

select
    (ca.avgvcpu-v.total_vcpu) as vcpu,
    (ca.avgvram-v.total_vram) as vram,
    (ca.avghdd-v.total_hdd) as hdd,
    Concat(lower(v.vdc),lower(v.org)) as org_vdc
from
    common.vmware_vm v
inner join case_avg  ca on
    ca.pod = v.pod and ca.report_date = v.report_date 
group by org_vdc 

我该如何解决此问题？