Mimic实体化量图-ECMO

DROP MATERIALIZED VIEW IF EXISTS ecmo CASCADE;
CREATE MATERIALIZED VIEW ecmo AS
WITH s1 AS (
    SELECT 
        ch.stay_id,
        ch.charttime
    FROM 
        mimiciv_icu.chartevents ch 
    WHERE 
        itemid IN ('229266','229267','229268','229269',
                  '229270','229271','229272','229273','229274','229275',
                  '229276','229277','229278','229280','229363','229364',
                  '229365','229840','229841','229842','229843','229844',
                  '229845','229846','229847','229848','229849','229850',
                  '229851','229852','229853','229854','229855','229873',
                  '229874','229875','229876','229877','229878','229879',
                  '230159','230160','230161','230162','230163','230164',
                  '230165','230166','230167','230168','230169','230170',
                  '230171')
),
s2 AS (
    SELECT 
        stay_id,
        MIN(charttime) AS starttime,
        MAX(charttime) AS endtime
    FROM 
        s1
    GROUP BY 
        stay_id
)
SELECT 
    stay_id,
    starttime,
    endtime,
    CEIL(EXTRACT(EPOCH FROM (endtime - starttime)) / 86400) AS days_interval
FROM 
    s2;