02 · Temporal (As-Of) Joins

This notebook demonstrates temporal joins in Featurizer using a healthcare scenario:

Patients (target entity) with admission dates
Care Plans (related entity) with plan dates

The key concept is the as-of join: for each patient row, we want features from the most recent care plan as of that patient’s admission date.

1. Setup

import sys
from pathlib import Path

# This tutorial is database-free: it loads the config and inspects the
# synthesized features and the generated SQL — none of which touch a
# database. To actually *execute* the features against PostgreSQL, run the
# example script instead (`just example <NN>`, or create_data.py +
# run_example.py with DATABASE_URL / PG* set). See the example README.
sys.path.insert(0, str(Path.cwd().parent.parent))

2. Understanding Temporal Relationships

The configuration defines a temporal relationship with mode: as_of:

with open("config.yaml") as f:
    print(f.read())

# Healthcare feature generation: Patients with temporal Care Plans

target: patients
max_depth: 2

intervals:
  - P30D  # Last 30 days
  - P90D  # Last 90 days

# A focused primitive set (the full default set would exceed PostgreSQL's 1664
# columns-per-row limit on this config). Includes the rolling ordered-set stats
# — rolling_median / rolling_iqr render as correlated subqueries (PostgreSQL
# forbids OVER on percentile_cont), exercised end to end here.
aggregations:
  - count
  - sum
  - mean
  - min
  - max
  - stddev
  - median
transformations:
  - identity
  - abs
  - lag_1
  - rolling_mean_7
  - rolling_median_7
  - rolling_iqr_7

entities:
  - alias: patients
    id: patient_id
    table: patients
    temporal_ix: admission_date
    variables:
      age:
        type: numeric
      severity_level:
        type: categorical

  - alias: care_plans
    id: plan_id
    table: care_plans
    temporal_ix: plan_date
    variables:
      treatment_type:
        type: categorical
      cost:
        type: numeric

relationships:
  - parent:
      entity: patients
      key: patient_id
    child:
      entity: care_plans
      key: patient_id
    temporal:
      mode: as_of
      grace: P7D  # Allow matching plans up to 7 days in the future
      child_time: plan_date

Key Temporal Configuration:

temporal:
  mode: as_of        # Enable as-of join semantics
  grace: P7D         # Allow matching up to 7 days in the future
  child_time: plan_date  # Override child entity's temporal column

This means: for each patient admission, find the most recent care plan where plan_date <= admission_date + 7 days.

3. Load Configuration

from featurizer import Featurizer

featurizer = Featurizer("config.yaml")

print(f"Target: {featurizer.target.alias}")
print(f"Intervals: {featurizer.intervals}")

[32m2026-06-21 13:29:15.899[0m | [34m[1mDEBUG   [0m | [36mfeaturizer.planner[0m:[36mplan[0m:[36m230[0m - [34m[1mStarting feature build for target patients[0m


[32m2026-06-21 13:29:15.900[0m | [34m[1mDEBUG   [0m | [36mfeaturizer.planner[0m:[36m_build_features[0m:[36m256[0m - [34m[1mbuild_features(patients) depth=0[0m


[32m2026-06-21 13:29:15.900[0m | [34m[1mDEBUG   [0m | [36mfeaturizer.planner[0m:[36m_build_features[0m:[36m256[0m - [34m[1mbuild_features(care_plans) depth=1[0m


[32m2026-06-21 13:29:15.900[0m | [1mINFO    [0m | [36mfeaturizer.planner[0m:[36m_build_features[0m:[36m276[0m - [1mMaximum recursion depth reached at depth 2; materializing care_plans without traversing further.[0m


[32m2026-06-21 13:29:15.900[0m | [34m[1mDEBUG   [0m | [36mfeaturizer.planner[0m:[36m_build_aggregations[0m:[36m1014[0m - [34m[1mProcessing backward relationship Entity(patients).patient_id -> Entity(care_plans).patient_id[0m


[32m2026-06-21 13:29:15.901[0m | [33m[1mWARNING [0m | [36mfeaturizer.planner[0m:[36m_apply_direct_roles[0m:[36m1155[0m - [33m[1mDirect variable 'patients.severity_level' (type: categorical) will pass through as a raw string column and is likely to crash a downstream encoder. Set role: categorical (with a declared vocabulary or a PostgreSQL ENUM) to one-hot encode it, or role: identifier to exclude it.[0m


Target: patients
Intervals: ['P30D', 'P90D']

# Examine the temporal relationship
for rel in featurizer.relationships:
    print(f"Relationship: {rel.parent.alias} -> {rel.child.alias}")
    print(f"  Temporal mode: {rel.temporal_mode}")
    print(f"  Grace period: {rel.temporal_grace}")
    print(f"  Child timestamp: {rel.temporal_child_field}")

Relationship: patients -> care_plans
  Temporal mode: as_of
  Grace period: P7D
  Child timestamp: None

4. Examining the Generated SQL

The key difference from regular joins is the LEFT JOIN LATERAL clause.

sql = featurizer.query

# Find the LATERAL join
if "lateral" in sql.lower():
    print("Temporal join generates LEFT JOIN LATERAL:")
    print("=" * 60)

    # Extract the lateral join portion
    lines = sql.split("\n")
    in_lateral = False
    for line in lines:
        if "lateral" in line.lower():
            in_lateral = True
        if in_lateral:
            print(line)
            if ") as" in line.lower() and "on true" in line.lower():
                break

[32m2026-06-21 13:29:15.922[0m | [34m[1mDEBUG   [0m | [36mfeaturizer.sql[0m:[36mrender[0m:[36m40[0m - [34m[1mRendered SQL for target 'patients': 5 CTEs, 248797 chars[0m


Temporal join generates LEFT JOIN LATERAL:
============================================================
        cross join lateral (

        with


        -- sythetize aggregations and direct features for care_plans
        care_plans_synth as (
        select
        care_plans.plan_id, care_plans.plan_date, care_plans.patient_id, cost, treatment_type
        from care_plans


        )
        ,
        -- transform care_plans
        care_plans_transform as (
        select
        plan_id, plan_date, patient_id,  abs(cost)  as "ABS(care_plans.cost)" , lag(cost, 1) over (partition by plan_id order by plan_date) as "LAG_1(care_plans.cost)" , lag(treatment_type, 1) over (partition by plan_id order by plan_date) as "LAG_1(care_plans.treatment_type)" , ((select percentile_cont(0.75) within group (order by _w.v) from (select care_plans_synth.cost as v from care_plans_synth where care_plans_synth.plan_id = _ego.plan_id and care_plans_synth.plan_date <= _ego.plan_date order by care_plans_synth.plan_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select care_plans_synth.cost as v from care_plans_synth where care_plans_synth.plan_id = _ego.plan_id and care_plans_synth.plan_date <= _ego.plan_date order by care_plans_synth.plan_date desc limit 7) _w)) as "ROLLING_IQR_7(care_plans.cost)" , avg(cost) over (partition by plan_id order by plan_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(care_plans.cost)" , (select percentile_cont(0.5) within group (order by _w.v) from (select care_plans_synth.cost as v from care_plans_synth where care_plans_synth.plan_id = _ego.plan_id and care_plans_synth.plan_date <= _ego.plan_date order by care_plans_synth.plan_date desc limit 7) _w) as "ROLLING_MEDIAN_7(care_plans.cost)" , cost as cost, treatment_type as treatment_type
        from care_plans_synth _ego
        )
        ,
        -- Aggregate for patients
        care_plans_aggs_for_patients as (
        select
        care_plans_transform.patient_id,
        count( "LAG_1(care_plans.treatment_type)" ) as "COUNT(care_plans.LAG_1(care_plans.treatment_type))" ,count( "LAG_1(care_plans.treatment_type)" )  filter (where daterange((aod.as_of_date - interval 'P90D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "COUNT(care_plans.LAG_1(care_plans.treatment_type)|inte~4f9badff" ,count( "LAG_1(care_plans.treatment_type)" )  filter (where daterange((aod.as_of_date - interval 'P30D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "COUNT(care_plans.LAG_1(care_plans.treatment_type)|inte~d7382445" ,count( plan_date ) as "COUNT(care_plans.plan_date)" ,count( plan_date )  filter (where daterange((aod.as_of_date - interval 'P30D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "COUNT(care_plans.plan_date|interval=P30D)" ,count( plan_date )  filter (where daterange((aod.as_of_date - interval 'P90D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "COUNT(care_plans.plan_date|interval=P90D)" ,count( plan_id ) as "COUNT(care_plans.plan_id)" ,count( plan_id )  filter (where daterange((aod.as_of_date - interval 'P30D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "COUNT(care_plans.plan_id|interval=P30D)" ,count( plan_id )  filter (where daterange((aod.as_of_date - interval 'P90D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "COUNT(care_plans.plan_id|interval=P90D)" ,count( treatment_type ) as "COUNT(care_plans.treatment_type)" ,count( treatment_type )  filter (where daterange((aod.as_of_date - interval 'P30D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "COUNT(care_plans.treatment_type|interval=P30D)" ,count( treatment_type )  filter (where daterange((aod.as_of_date - interval 'P90D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "COUNT(care_plans.treatment_type|interval=P90D)" ,max( "ABS(care_plans.cost)" ) as "MAX(care_plans.ABS(care_plans.cost))" ,max( "ABS(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P30D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "MAX(care_plans.ABS(care_plans.cost)|interval=P30D)" ,max( "ABS(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P90D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "MAX(care_plans.ABS(care_plans.cost)|interval=P90D)" ,max( "LAG_1(care_plans.cost)" ) as "MAX(care_plans.LAG_1(care_plans.cost))" ,max( "LAG_1(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P30D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "MAX(care_plans.LAG_1(care_plans.cost)|interval=P30D)" ,max( "LAG_1(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P90D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "MAX(care_plans.LAG_1(care_plans.cost)|interval=P90D)" ,max( "ROLLING_IQR_7(care_plans.cost)" ) as "MAX(care_plans.ROLLING_IQR_7(care_plans.cost))" ,max( "ROLLING_IQR_7(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P30D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "MAX(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)" ,max( "ROLLING_IQR_7(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P90D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "MAX(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)" ,max( "ROLLING_MEAN_7(care_plans.cost)" ) as "MAX(care_plans.ROLLING_MEAN_7(care_plans.cost))" ,max( "ROLLING_MEAN_7(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P30D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "MAX(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D)" ,max( "ROLLING_MEAN_7(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P90D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "MAX(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D)" ,max( "ROLLING_MEDIAN_7(care_plans.cost)" ) as "MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost))" ,max( "ROLLING_MEDIAN_7(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P30D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D)" ,max( "ROLLING_MEDIAN_7(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P90D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D)" ,max( cost ) as "MAX(care_plans.cost)" ,max( cost )  filter (where daterange((aod.as_of_date - interval 'P30D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "MAX(care_plans.cost|interval=P30D)" ,max( cost )  filter (where daterange((aod.as_of_date - interval 'P90D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "MAX(care_plans.cost|interval=P90D)" ,avg( "ABS(care_plans.cost)" ) as "MEAN(care_plans.ABS(care_plans.cost))" ,avg( "ABS(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P30D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "MEAN(care_plans.ABS(care_plans.cost)|interval=P30D)" ,avg( "ABS(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P90D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "MEAN(care_plans.ABS(care_plans.cost)|interval=P90D)" ,avg( "LAG_1(care_plans.cost)" ) as "MEAN(care_plans.LAG_1(care_plans.cost))" ,avg( "LAG_1(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P30D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "MEAN(care_plans.LAG_1(care_plans.cost)|interval=P30D)" ,avg( "LAG_1(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P90D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "MEAN(care_plans.LAG_1(care_plans.cost)|interval=P90D)" ,avg( "ROLLING_IQR_7(care_plans.cost)" ) as "MEAN(care_plans.ROLLING_IQR_7(care_plans.cost))" ,avg( "ROLLING_IQR_7(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P30D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "MEAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)" ,avg( "ROLLING_IQR_7(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P90D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "MEAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)" ,avg( "ROLLING_MEAN_7(care_plans.cost)" ) as "MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost))" ,avg( "ROLLING_MEAN_7(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P30D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D)" ,avg( "ROLLING_MEAN_7(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P90D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D)" ,avg( "ROLLING_MEDIAN_7(care_plans.cost)" ) as "MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost))" ,avg( "ROLLING_MEDIAN_7(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P90D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|inte~f1347cdb" ,avg( "ROLLING_MEDIAN_7(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P30D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|inte~f15d471d" ,avg( cost ) as "MEAN(care_plans.cost)" ,avg( cost )  filter (where daterange((aod.as_of_date - interval 'P30D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "MEAN(care_plans.cost|interval=P30D)" ,avg( cost )  filter (where daterange((aod.as_of_date - interval 'P90D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "MEAN(care_plans.cost|interval=P90D)" ,percentile_cont(0.5) within group(order by "ABS(care_plans.cost)") as "MEDIAN(care_plans.ABS(care_plans.cost))" ,percentile_cont(0.5) within group(order by "ABS(care_plans.cost)")  filter (where daterange((aod.as_of_date - interval 'P30D')::date, aod.as_of_date::date, '[]') @> plan_date::date) as "MEDIAN(care_plans.ABS(care_plans.cost)|interval=P30D)" ,percentile_cont(0.5) within group(order by "ABS(care_plans.cost)")  filter (where daterange((aod.as_of_date - interval 'P90D')::date, aod.as_of_date::date, '[]') @> plan_date::date) as "MEDIAN(care_plans.ABS(care_plans.cost)|interval=P90D)" ,percentile_cont(0.5) within group(order by "LAG_1(care_plans.cost)") as "MEDIAN(care_plans.LAG_1(care_plans.cost))" ,percentile_cont(0.5) within group(order by "LAG_1(care_plans.cost)")  filter (where daterange((aod.as_of_date - interval 'P30D')::date, aod.as_of_date::date, '[]') @> plan_date::date) as "MEDIAN(care_plans.LAG_1(care_plans.cost)|interval=P30D)" ,percentile_cont(0.5) within group(order by "LAG_1(care_plans.cost)")  filter (where daterange((aod.as_of_date - interval 'P90D')::date, aod.as_of_date::date, '[]') @> plan_date::date) as "MEDIAN(care_plans.LAG_1(care_plans.cost)|interval=P90D)" ,percentile_cont(0.5) within group(order by "ROLLING_IQR_7(care_plans.cost)") as "MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost))" ,percentile_cont(0.5) within group(order by "ROLLING_IQR_7(care_plans.cost)")  filter (where daterange((aod.as_of_date - interval 'P30D')::date, aod.as_of_date::date, '[]') @> plan_date::date) as "MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)" ,percentile_cont(0.5) within group(order by "ROLLING_IQR_7(care_plans.cost)")  filter (where daterange((aod.as_of_date - interval 'P90D')::date, aod.as_of_date::date, '[]') @> plan_date::date) as "MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)" ,percentile_cont(0.5) within group(order by "ROLLING_MEAN_7(care_plans.cost)") as "MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost))" ,percentile_cont(0.5) within group(order by "ROLLING_MEAN_7(care_plans.cost)")  filter (where daterange((aod.as_of_date - interval 'P30D')::date, aod.as_of_date::date, '[]') @> plan_date::date) as "MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~3455f299" ,percentile_cont(0.5) within group(order by "ROLLING_MEAN_7(care_plans.cost)")  filter (where daterange((aod.as_of_date - interval 'P90D')::date, aod.as_of_date::date, '[]') @> plan_date::date) as "MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~5a5a927f" ,percentile_cont(0.5) within group(order by "ROLLING_MEDIAN_7(care_plans.cost)") as "MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost))" ,percentile_cont(0.5) within group(order by "ROLLING_MEDIAN_7(care_plans.cost)")  filter (where daterange((aod.as_of_date - interval 'P30D')::date, aod.as_of_date::date, '[]') @> plan_date::date) as "MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~3923dfc3" ,percentile_cont(0.5) within group(order by "ROLLING_MEDIAN_7(care_plans.cost)")  filter (where daterange((aod.as_of_date - interval 'P90D')::date, aod.as_of_date::date, '[]') @> plan_date::date) as "MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~983564d1" ,percentile_cont(0.5) within group(order by cost) as "MEDIAN(care_plans.cost)" ,percentile_cont(0.5) within group(order by cost)  filter (where daterange((aod.as_of_date - interval 'P30D')::date, aod.as_of_date::date, '[]') @> plan_date::date) as "MEDIAN(care_plans.cost|interval=P30D)" ,percentile_cont(0.5) within group(order by cost)  filter (where daterange((aod.as_of_date - interval 'P90D')::date, aod.as_of_date::date, '[]') @> plan_date::date) as "MEDIAN(care_plans.cost|interval=P90D)" ,min( "ABS(care_plans.cost)" ) as "MIN(care_plans.ABS(care_plans.cost))" ,min( "ABS(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P30D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "MIN(care_plans.ABS(care_plans.cost)|interval=P30D)" ,min( "ABS(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P90D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "MIN(care_plans.ABS(care_plans.cost)|interval=P90D)" ,min( "LAG_1(care_plans.cost)" ) as "MIN(care_plans.LAG_1(care_plans.cost))" ,min( "LAG_1(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P30D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "MIN(care_plans.LAG_1(care_plans.cost)|interval=P30D)" ,min( "LAG_1(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P90D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "MIN(care_plans.LAG_1(care_plans.cost)|interval=P90D)" ,min( "ROLLING_IQR_7(care_plans.cost)" ) as "MIN(care_plans.ROLLING_IQR_7(care_plans.cost))" ,min( "ROLLING_IQR_7(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P30D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "MIN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)" ,min( "ROLLING_IQR_7(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P90D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "MIN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)" ,min( "ROLLING_MEAN_7(care_plans.cost)" ) as "MIN(care_plans.ROLLING_MEAN_7(care_plans.cost))" ,min( "ROLLING_MEAN_7(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P30D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "MIN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D)" ,min( "ROLLING_MEAN_7(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P90D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "MIN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D)" ,min( "ROLLING_MEDIAN_7(care_plans.cost)" ) as "MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost))" ,min( "ROLLING_MEDIAN_7(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P30D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D)" ,min( "ROLLING_MEDIAN_7(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P90D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D)" ,min( cost ) as "MIN(care_plans.cost)" ,min( cost )  filter (where daterange((aod.as_of_date - interval 'P30D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "MIN(care_plans.cost|interval=P30D)" ,min( cost )  filter (where daterange((aod.as_of_date - interval 'P90D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "MIN(care_plans.cost|interval=P90D)" ,stddev( "ABS(care_plans.cost)" ) as "STDDEV(care_plans.ABS(care_plans.cost))" ,stddev( "ABS(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P30D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "STDDEV(care_plans.ABS(care_plans.cost)|interval=P30D)" ,stddev( "ABS(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P90D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "STDDEV(care_plans.ABS(care_plans.cost)|interval=P90D)" ,stddev( "LAG_1(care_plans.cost)" ) as "STDDEV(care_plans.LAG_1(care_plans.cost))" ,stddev( "LAG_1(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P30D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "STDDEV(care_plans.LAG_1(care_plans.cost)|interval=P30D)" ,stddev( "LAG_1(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P90D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "STDDEV(care_plans.LAG_1(care_plans.cost)|interval=P90D)" ,stddev( "ROLLING_IQR_7(care_plans.cost)" ) as "STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost))" ,stddev( "ROLLING_IQR_7(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P30D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)" ,stddev( "ROLLING_IQR_7(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P90D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)" ,stddev( "ROLLING_MEAN_7(care_plans.cost)" ) as "STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost))" ,stddev( "ROLLING_MEAN_7(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P90D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~96926c25" ,stddev( "ROLLING_MEAN_7(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P30D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~f96e61ed" ,stddev( "ROLLING_MEDIAN_7(care_plans.cost)" ) as "STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost))" ,stddev( "ROLLING_MEDIAN_7(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P30D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~06ee3896" ,stddev( "ROLLING_MEDIAN_7(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P90D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~55d39dc4" ,stddev( cost ) as "STDDEV(care_plans.cost)" ,stddev( cost )  filter (where daterange((aod.as_of_date - interval 'P30D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "STDDEV(care_plans.cost|interval=P30D)" ,stddev( cost )  filter (where daterange((aod.as_of_date - interval 'P90D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "STDDEV(care_plans.cost|interval=P90D)" ,sum( "ABS(care_plans.cost)" ) as "SUM(care_plans.ABS(care_plans.cost))" ,sum( "ABS(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P30D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "SUM(care_plans.ABS(care_plans.cost)|interval=P30D)" ,sum( "ABS(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P90D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "SUM(care_plans.ABS(care_plans.cost)|interval=P90D)" ,sum( "LAG_1(care_plans.cost)" ) as "SUM(care_plans.LAG_1(care_plans.cost))" ,sum( "LAG_1(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P30D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "SUM(care_plans.LAG_1(care_plans.cost)|interval=P30D)" ,sum( "LAG_1(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P90D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "SUM(care_plans.LAG_1(care_plans.cost)|interval=P90D)" ,sum( "ROLLING_IQR_7(care_plans.cost)" ) as "SUM(care_plans.ROLLING_IQR_7(care_plans.cost))" ,sum( "ROLLING_IQR_7(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P30D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "SUM(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)" ,sum( "ROLLING_IQR_7(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P90D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "SUM(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)" ,sum( "ROLLING_MEAN_7(care_plans.cost)" ) as "SUM(care_plans.ROLLING_MEAN_7(care_plans.cost))" ,sum( "ROLLING_MEAN_7(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P30D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "SUM(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D)" ,sum( "ROLLING_MEAN_7(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P90D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "SUM(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D)" ,sum( "ROLLING_MEDIAN_7(care_plans.cost)" ) as "SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost))" ,sum( "ROLLING_MEDIAN_7(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P30D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D)" ,sum( "ROLLING_MEDIAN_7(care_plans.cost)" )  filter (where daterange((aod.as_of_date - interval 'P90D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D)" ,sum( cost ) as "SUM(care_plans.cost)" ,sum( cost )  filter (where daterange((aod.as_of_date - interval 'P30D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "SUM(care_plans.cost|interval=P30D)" ,sum( cost )  filter (where daterange((aod.as_of_date - interval 'P90D')::date, aod.as_of_date::date, '[]') @> plan_date::date)  as "SUM(care_plans.cost|interval=P90D)"
        from care_plans_transform
         where plan_date <= aod.as_of_date
        group by patient_id
        )
        ,
        -- sythetize aggregations and direct features for patients
        patients_synth as (
        select
        patients.patient_id, patients.admission_date, "COUNT(care_plans.LAG_1(care_plans.treatment_type))", "COUNT(care_plans.LAG_1(care_plans.treatment_type)|inte~4f9badff", "COUNT(care_plans.LAG_1(care_plans.treatment_type)|inte~d7382445", "COUNT(care_plans.plan_date)", "COUNT(care_plans.plan_date|interval=P30D)", "COUNT(care_plans.plan_date|interval=P90D)", "COUNT(care_plans.plan_id)", "COUNT(care_plans.plan_id|interval=P30D)", "COUNT(care_plans.plan_id|interval=P90D)", "COUNT(care_plans.treatment_type)", "COUNT(care_plans.treatment_type|interval=P30D)", "COUNT(care_plans.treatment_type|interval=P90D)", "MAX(care_plans.ABS(care_plans.cost))", "MAX(care_plans.ABS(care_plans.cost)|interval=P30D)", "MAX(care_plans.ABS(care_plans.cost)|interval=P90D)", "MAX(care_plans.LAG_1(care_plans.cost))", "MAX(care_plans.LAG_1(care_plans.cost)|interval=P30D)", "MAX(care_plans.LAG_1(care_plans.cost)|interval=P90D)", "MAX(care_plans.ROLLING_IQR_7(care_plans.cost))", "MAX(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)", "MAX(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)", "MAX(care_plans.ROLLING_MEAN_7(care_plans.cost))", "MAX(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D)", "MAX(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D)", "MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost))", "MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D)", "MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D)", "MAX(care_plans.cost)", "MAX(care_plans.cost|interval=P30D)", "MAX(care_plans.cost|interval=P90D)", "MEAN(care_plans.ABS(care_plans.cost))", "MEAN(care_plans.ABS(care_plans.cost)|interval=P30D)", "MEAN(care_plans.ABS(care_plans.cost)|interval=P90D)", "MEAN(care_plans.LAG_1(care_plans.cost))", "MEAN(care_plans.LAG_1(care_plans.cost)|interval=P30D)", "MEAN(care_plans.LAG_1(care_plans.cost)|interval=P90D)", "MEAN(care_plans.ROLLING_IQR_7(care_plans.cost))", "MEAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)", "MEAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)", "MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost))", "MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D)", "MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D)", "MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost))", "MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|inte~f1347cdb", "MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|inte~f15d471d", "MEAN(care_plans.cost)", "MEAN(care_plans.cost|interval=P30D)", "MEAN(care_plans.cost|interval=P90D)", "MEDIAN(care_plans.ABS(care_plans.cost))", "MEDIAN(care_plans.ABS(care_plans.cost)|interval=P30D)", "MEDIAN(care_plans.ABS(care_plans.cost)|interval=P90D)", "MEDIAN(care_plans.LAG_1(care_plans.cost))", "MEDIAN(care_plans.LAG_1(care_plans.cost)|interval=P30D)", "MEDIAN(care_plans.LAG_1(care_plans.cost)|interval=P90D)", "MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost))", "MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)", "MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)", "MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost))", "MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~3455f299", "MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~5a5a927f", "MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost))", "MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~3923dfc3", "MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~983564d1", "MEDIAN(care_plans.cost)", "MEDIAN(care_plans.cost|interval=P30D)", "MEDIAN(care_plans.cost|interval=P90D)", "MIN(care_plans.ABS(care_plans.cost))", "MIN(care_plans.ABS(care_plans.cost)|interval=P30D)", "MIN(care_plans.ABS(care_plans.cost)|interval=P90D)", "MIN(care_plans.LAG_1(care_plans.cost))", "MIN(care_plans.LAG_1(care_plans.cost)|interval=P30D)", "MIN(care_plans.LAG_1(care_plans.cost)|interval=P90D)", "MIN(care_plans.ROLLING_IQR_7(care_plans.cost))", "MIN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)", "MIN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)", "MIN(care_plans.ROLLING_MEAN_7(care_plans.cost))", "MIN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D)", "MIN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D)", "MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost))", "MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D)", "MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D)", "MIN(care_plans.cost)", "MIN(care_plans.cost|interval=P30D)", "MIN(care_plans.cost|interval=P90D)", "STDDEV(care_plans.ABS(care_plans.cost))", "STDDEV(care_plans.ABS(care_plans.cost)|interval=P30D)", "STDDEV(care_plans.ABS(care_plans.cost)|interval=P90D)", "STDDEV(care_plans.LAG_1(care_plans.cost))", "STDDEV(care_plans.LAG_1(care_plans.cost)|interval=P30D)", "STDDEV(care_plans.LAG_1(care_plans.cost)|interval=P90D)", "STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost))", "STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)", "STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)", "STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost))", "STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~96926c25", "STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~f96e61ed", "STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost))", "STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~06ee3896", "STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~55d39dc4", "STDDEV(care_plans.cost)", "STDDEV(care_plans.cost|interval=P30D)", "STDDEV(care_plans.cost|interval=P90D)", "SUM(care_plans.ABS(care_plans.cost))", "SUM(care_plans.ABS(care_plans.cost)|interval=P30D)", "SUM(care_plans.ABS(care_plans.cost)|interval=P90D)", "SUM(care_plans.LAG_1(care_plans.cost))", "SUM(care_plans.LAG_1(care_plans.cost)|interval=P30D)", "SUM(care_plans.LAG_1(care_plans.cost)|interval=P90D)", "SUM(care_plans.ROLLING_IQR_7(care_plans.cost))", "SUM(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)", "SUM(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)", "SUM(care_plans.ROLLING_MEAN_7(care_plans.cost))", "SUM(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D)", "SUM(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D)", "SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost))", "SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D)", "SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D)", "SUM(care_plans.cost)", "SUM(care_plans.cost|interval=P30D)", "SUM(care_plans.cost|interval=P90D)", age, severity_level
        from patients
         left join
         care_plans_aggs_for_patients on care_plans_aggs_for_patients.patient_id = patients.patient_id
        )
        ,
        -- transform patients
        patients_transform as (
        select
        patient_id, admission_date,  abs("COUNT(care_plans.LAG_1(care_plans.treatment_type))")  as "ABS(patients.COUNT(care_plans.LAG_1(care_plans.treatment_type)))" ,  abs("COUNT(care_plans.LAG_1(care_plans.treatment_type)|inte~4f9badff")  as "ABS(patients.COUNT(care_plans.LAG_1(care_plans.treatment_type)|inte~4f9badff)" ,  abs("COUNT(care_plans.LAG_1(care_plans.treatment_type)|inte~d7382445")  as "ABS(patients.COUNT(care_plans.LAG_1(care_plans.treatment_type)|inte~d7382445)" ,  abs("COUNT(care_plans.plan_date)")  as "ABS(patients.COUNT(care_plans.plan_date))" ,  abs("COUNT(care_plans.plan_date|interval=P30D)")  as "ABS(patients.COUNT(care_plans.plan_date|interval=P30D))" ,  abs("COUNT(care_plans.plan_date|interval=P90D)")  as "ABS(patients.COUNT(care_plans.plan_date|interval=P90D))" ,  abs("COUNT(care_plans.plan_id)")  as "ABS(patients.COUNT(care_plans.plan_id))" ,  abs("COUNT(care_plans.plan_id|interval=P30D)")  as "ABS(patients.COUNT(care_plans.plan_id|interval=P30D))" ,  abs("COUNT(care_plans.plan_id|interval=P90D)")  as "ABS(patients.COUNT(care_plans.plan_id|interval=P90D))" ,  abs("COUNT(care_plans.treatment_type)")  as "ABS(patients.COUNT(care_plans.treatment_type))" ,  abs("COUNT(care_plans.treatment_type|interval=P30D)")  as "ABS(patients.COUNT(care_plans.treatment_type|interval=P30D))" ,  abs("COUNT(care_plans.treatment_type|interval=P90D)")  as "ABS(patients.COUNT(care_plans.treatment_type|interval=P90D))" ,  abs("MAX(care_plans.ABS(care_plans.cost))")  as "ABS(patients.MAX(care_plans.ABS(care_plans.cost)))" ,  abs("MAX(care_plans.ABS(care_plans.cost)|interval=P30D)")  as "ABS(patients.MAX(care_plans.ABS(care_plans.cost)|interval=P30D))" ,  abs("MAX(care_plans.ABS(care_plans.cost)|interval=P90D)")  as "ABS(patients.MAX(care_plans.ABS(care_plans.cost)|interval=P90D))" ,  abs("MAX(care_plans.LAG_1(care_plans.cost))")  as "ABS(patients.MAX(care_plans.LAG_1(care_plans.cost)))" ,  abs("MAX(care_plans.LAG_1(care_plans.cost)|interval=P30D)")  as "ABS(patients.MAX(care_plans.LAG_1(care_plans.cost)|interval=P30D))" ,  abs("MAX(care_plans.LAG_1(care_plans.cost)|interval=P90D)")  as "ABS(patients.MAX(care_plans.LAG_1(care_plans.cost)|interval=P90D))" ,  abs("MAX(care_plans.ROLLING_IQR_7(care_plans.cost))")  as "ABS(patients.MAX(care_plans.ROLLING_IQR_7(care_plans.cost)))" ,  abs("MAX(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)")  as "ABS(patients.MAX(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D))" ,  abs("MAX(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)")  as "ABS(patients.MAX(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D))" ,  abs("MAX(care_plans.ROLLING_MEAN_7(care_plans.cost))")  as "ABS(patients.MAX(care_plans.ROLLING_MEAN_7(care_plans.cost)))" ,  abs("MAX(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D)")  as "ABS(patients.MAX(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D))" ,  abs("MAX(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D)")  as "ABS(patients.MAX(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D))" ,  abs("MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost))")  as "ABS(patients.MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost)))" ,  abs("MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D)")  as "ABS(patients.MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D))" ,  abs("MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D)")  as "ABS(patients.MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D))" ,  abs("MAX(care_plans.cost)")  as "ABS(patients.MAX(care_plans.cost))" ,  abs("MAX(care_plans.cost|interval=P30D)")  as "ABS(patients.MAX(care_plans.cost|interval=P30D))" ,  abs("MAX(care_plans.cost|interval=P90D)")  as "ABS(patients.MAX(care_plans.cost|interval=P90D))" ,  abs("MEAN(care_plans.ABS(care_plans.cost))")  as "ABS(patients.MEAN(care_plans.ABS(care_plans.cost)))" ,  abs("MEAN(care_plans.ABS(care_plans.cost)|interval=P30D)")  as "ABS(patients.MEAN(care_plans.ABS(care_plans.cost)|interval=P30D))" ,  abs("MEAN(care_plans.ABS(care_plans.cost)|interval=P90D)")  as "ABS(patients.MEAN(care_plans.ABS(care_plans.cost)|interval=P90D))" ,  abs("MEAN(care_plans.LAG_1(care_plans.cost))")  as "ABS(patients.MEAN(care_plans.LAG_1(care_plans.cost)))" ,  abs("MEAN(care_plans.LAG_1(care_plans.cost)|interval=P30D)")  as "ABS(patients.MEAN(care_plans.LAG_1(care_plans.cost)|interval=P30D))" ,  abs("MEAN(care_plans.LAG_1(care_plans.cost)|interval=P90D)")  as "ABS(patients.MEAN(care_plans.LAG_1(care_plans.cost)|interval=P90D))" ,  abs("MEAN(care_plans.ROLLING_IQR_7(care_plans.cost))")  as "ABS(patients.MEAN(care_plans.ROLLING_IQR_7(care_plans.cost)))" ,  abs("MEAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)")  as "ABS(patients.MEAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D))" ,  abs("MEAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)")  as "ABS(patients.MEAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D))" ,  abs("MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost))")  as "ABS(patients.MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost)))" ,  abs("MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D)")  as "ABS(patients.MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D))" ,  abs("MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D)")  as "ABS(patients.MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D))" ,  abs("MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost))")  as "ABS(patients.MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)))" ,  abs("MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|inte~f1347cdb")  as "ABS(patients.MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|inte~f1347cdb)" ,  abs("MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|inte~f15d471d")  as "ABS(patients.MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|inte~f15d471d)" ,  abs("MEAN(care_plans.cost)")  as "ABS(patients.MEAN(care_plans.cost))" ,  abs("MEAN(care_plans.cost|interval=P30D)")  as "ABS(patients.MEAN(care_plans.cost|interval=P30D))" ,  abs("MEAN(care_plans.cost|interval=P90D)")  as "ABS(patients.MEAN(care_plans.cost|interval=P90D))" ,  abs("MEDIAN(care_plans.ABS(care_plans.cost))")  as "ABS(patients.MEDIAN(care_plans.ABS(care_plans.cost)))" ,  abs("MEDIAN(care_plans.ABS(care_plans.cost)|interval=P30D)")  as "ABS(patients.MEDIAN(care_plans.ABS(care_plans.cost)|interval=P30D))" ,  abs("MEDIAN(care_plans.ABS(care_plans.cost)|interval=P90D)")  as "ABS(patients.MEDIAN(care_plans.ABS(care_plans.cost)|interval=P90D))" ,  abs("MEDIAN(care_plans.LAG_1(care_plans.cost))")  as "ABS(patients.MEDIAN(care_plans.LAG_1(care_plans.cost)))" ,  abs("MEDIAN(care_plans.LAG_1(care_plans.cost)|interval=P30D)")  as "ABS(patients.MEDIAN(care_plans.LAG_1(care_plans.cost)|interval=P30D))" ,  abs("MEDIAN(care_plans.LAG_1(care_plans.cost)|interval=P90D)")  as "ABS(patients.MEDIAN(care_plans.LAG_1(care_plans.cost)|interval=P90D))" ,  abs("MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost))")  as "ABS(patients.MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost)))" ,  abs("MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)")  as "ABS(patients.MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D))" ,  abs("MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)")  as "ABS(patients.MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D))" ,  abs("MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost))")  as "ABS(patients.MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost)))" ,  abs("MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~3455f299")  as "ABS(patients.MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~3455f299)" ,  abs("MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~5a5a927f")  as "ABS(patients.MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~5a5a927f)" ,  abs("MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost))")  as "ABS(patients.MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)))" ,  abs("MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~3923dfc3")  as "ABS(patients.MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~3923dfc3)" ,  abs("MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~983564d1")  as "ABS(patients.MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~983564d1)" ,  abs("MEDIAN(care_plans.cost)")  as "ABS(patients.MEDIAN(care_plans.cost))" ,  abs("MEDIAN(care_plans.cost|interval=P30D)")  as "ABS(patients.MEDIAN(care_plans.cost|interval=P30D))" ,  abs("MEDIAN(care_plans.cost|interval=P90D)")  as "ABS(patients.MEDIAN(care_plans.cost|interval=P90D))" ,  abs("MIN(care_plans.ABS(care_plans.cost))")  as "ABS(patients.MIN(care_plans.ABS(care_plans.cost)))" ,  abs("MIN(care_plans.ABS(care_plans.cost)|interval=P30D)")  as "ABS(patients.MIN(care_plans.ABS(care_plans.cost)|interval=P30D))" ,  abs("MIN(care_plans.ABS(care_plans.cost)|interval=P90D)")  as "ABS(patients.MIN(care_plans.ABS(care_plans.cost)|interval=P90D))" ,  abs("MIN(care_plans.LAG_1(care_plans.cost))")  as "ABS(patients.MIN(care_plans.LAG_1(care_plans.cost)))" ,  abs("MIN(care_plans.LAG_1(care_plans.cost)|interval=P30D)")  as "ABS(patients.MIN(care_plans.LAG_1(care_plans.cost)|interval=P30D))" ,  abs("MIN(care_plans.LAG_1(care_plans.cost)|interval=P90D)")  as "ABS(patients.MIN(care_plans.LAG_1(care_plans.cost)|interval=P90D))" ,  abs("MIN(care_plans.ROLLING_IQR_7(care_plans.cost))")  as "ABS(patients.MIN(care_plans.ROLLING_IQR_7(care_plans.cost)))" ,  abs("MIN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)")  as "ABS(patients.MIN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D))" ,  abs("MIN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)")  as "ABS(patients.MIN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D))" ,  abs("MIN(care_plans.ROLLING_MEAN_7(care_plans.cost))")  as "ABS(patients.MIN(care_plans.ROLLING_MEAN_7(care_plans.cost)))" ,  abs("MIN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D)")  as "ABS(patients.MIN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D))" ,  abs("MIN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D)")  as "ABS(patients.MIN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D))" ,  abs("MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost))")  as "ABS(patients.MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)))" ,  abs("MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D)")  as "ABS(patients.MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D))" ,  abs("MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D)")  as "ABS(patients.MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D))" ,  abs("MIN(care_plans.cost)")  as "ABS(patients.MIN(care_plans.cost))" ,  abs("MIN(care_plans.cost|interval=P30D)")  as "ABS(patients.MIN(care_plans.cost|interval=P30D))" ,  abs("MIN(care_plans.cost|interval=P90D)")  as "ABS(patients.MIN(care_plans.cost|interval=P90D))" ,  abs("STDDEV(care_plans.ABS(care_plans.cost))")  as "ABS(patients.STDDEV(care_plans.ABS(care_plans.cost)))" ,  abs("STDDEV(care_plans.ABS(care_plans.cost)|interval=P30D)")  as "ABS(patients.STDDEV(care_plans.ABS(care_plans.cost)|interval=P30D))" ,  abs("STDDEV(care_plans.ABS(care_plans.cost)|interval=P90D)")  as "ABS(patients.STDDEV(care_plans.ABS(care_plans.cost)|interval=P90D))" ,  abs("STDDEV(care_plans.LAG_1(care_plans.cost))")  as "ABS(patients.STDDEV(care_plans.LAG_1(care_plans.cost)))" ,  abs("STDDEV(care_plans.LAG_1(care_plans.cost)|interval=P30D)")  as "ABS(patients.STDDEV(care_plans.LAG_1(care_plans.cost)|interval=P30D))" ,  abs("STDDEV(care_plans.LAG_1(care_plans.cost)|interval=P90D)")  as "ABS(patients.STDDEV(care_plans.LAG_1(care_plans.cost)|interval=P90D))" ,  abs("STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost))")  as "ABS(patients.STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost)))" ,  abs("STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)")  as "ABS(patients.STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D))" ,  abs("STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)")  as "ABS(patients.STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D))" ,  abs("STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost))")  as "ABS(patients.STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost)))" ,  abs("STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~96926c25")  as "ABS(patients.STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~96926c25)" ,  abs("STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~f96e61ed")  as "ABS(patients.STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~f96e61ed)" ,  abs("STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost))")  as "ABS(patients.STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost)))" ,  abs("STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~06ee3896")  as "ABS(patients.STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~06ee3896)" ,  abs("STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~55d39dc4")  as "ABS(patients.STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~55d39dc4)" ,  abs("STDDEV(care_plans.cost)")  as "ABS(patients.STDDEV(care_plans.cost))" ,  abs("STDDEV(care_plans.cost|interval=P30D)")  as "ABS(patients.STDDEV(care_plans.cost|interval=P30D))" ,  abs("STDDEV(care_plans.cost|interval=P90D)")  as "ABS(patients.STDDEV(care_plans.cost|interval=P90D))" ,  abs("SUM(care_plans.ABS(care_plans.cost))")  as "ABS(patients.SUM(care_plans.ABS(care_plans.cost)))" ,  abs("SUM(care_plans.ABS(care_plans.cost)|interval=P30D)")  as "ABS(patients.SUM(care_plans.ABS(care_plans.cost)|interval=P30D))" ,  abs("SUM(care_plans.ABS(care_plans.cost)|interval=P90D)")  as "ABS(patients.SUM(care_plans.ABS(care_plans.cost)|interval=P90D))" ,  abs("SUM(care_plans.LAG_1(care_plans.cost))")  as "ABS(patients.SUM(care_plans.LAG_1(care_plans.cost)))" ,  abs("SUM(care_plans.LAG_1(care_plans.cost)|interval=P30D)")  as "ABS(patients.SUM(care_plans.LAG_1(care_plans.cost)|interval=P30D))" ,  abs("SUM(care_plans.LAG_1(care_plans.cost)|interval=P90D)")  as "ABS(patients.SUM(care_plans.LAG_1(care_plans.cost)|interval=P90D))" ,  abs("SUM(care_plans.ROLLING_IQR_7(care_plans.cost))")  as "ABS(patients.SUM(care_plans.ROLLING_IQR_7(care_plans.cost)))" ,  abs("SUM(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)")  as "ABS(patients.SUM(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D))" ,  abs("SUM(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)")  as "ABS(patients.SUM(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D))" ,  abs("SUM(care_plans.ROLLING_MEAN_7(care_plans.cost))")  as "ABS(patients.SUM(care_plans.ROLLING_MEAN_7(care_plans.cost)))" ,  abs("SUM(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D)")  as "ABS(patients.SUM(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D))" ,  abs("SUM(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D)")  as "ABS(patients.SUM(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D))" ,  abs("SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost))")  as "ABS(patients.SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost)))" ,  abs("SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D)")  as "ABS(patients.SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D))" ,  abs("SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D)")  as "ABS(patients.SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D))" ,  abs("SUM(care_plans.cost)")  as "ABS(patients.SUM(care_plans.cost))" ,  abs("SUM(care_plans.cost|interval=P30D)")  as "ABS(patients.SUM(care_plans.cost|interval=P30D))" ,  abs("SUM(care_plans.cost|interval=P90D)")  as "ABS(patients.SUM(care_plans.cost|interval=P90D))" ,  abs(age)  as "ABS(patients.age)" , "COUNT(care_plans.LAG_1(care_plans.treatment_type))" as "COUNT(care_plans.LAG_1(care_plans.treatment_type))", "COUNT(care_plans.LAG_1(care_plans.treatment_type)|inte~4f9badff" as "COUNT(care_plans.LAG_1(care_plans.treatment_type)|inte~4f9badff", "COUNT(care_plans.LAG_1(care_plans.treatment_type)|inte~d7382445" as "COUNT(care_plans.LAG_1(care_plans.treatment_type)|inte~d7382445", "COUNT(care_plans.plan_date)" as "COUNT(care_plans.plan_date)", "COUNT(care_plans.plan_date|interval=P30D)" as "COUNT(care_plans.plan_date|interval=P30D)", "COUNT(care_plans.plan_date|interval=P90D)" as "COUNT(care_plans.plan_date|interval=P90D)", "COUNT(care_plans.plan_id)" as "COUNT(care_plans.plan_id)", "COUNT(care_plans.plan_id|interval=P30D)" as "COUNT(care_plans.plan_id|interval=P30D)", "COUNT(care_plans.plan_id|interval=P90D)" as "COUNT(care_plans.plan_id|interval=P90D)", "COUNT(care_plans.treatment_type)" as "COUNT(care_plans.treatment_type)", "COUNT(care_plans.treatment_type|interval=P30D)" as "COUNT(care_plans.treatment_type|interval=P30D)", "COUNT(care_plans.treatment_type|interval=P90D)" as "COUNT(care_plans.treatment_type|interval=P90D)", lag("COUNT(care_plans.LAG_1(care_plans.treatment_type))", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.COUNT(care_plans.LAG_1(care_plans.treatment_type)))" , lag("COUNT(care_plans.LAG_1(care_plans.treatment_type)|inte~4f9badff", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.COUNT(care_plans.LAG_1(care_plans.treatment_type)|inte~4f9badff)" , lag("COUNT(care_plans.LAG_1(care_plans.treatment_type)|inte~d7382445", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.COUNT(care_plans.LAG_1(care_plans.treatment_type)|inte~d7382445)" , lag("COUNT(care_plans.plan_date)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.COUNT(care_plans.plan_date))" , lag("COUNT(care_plans.plan_date|interval=P30D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.COUNT(care_plans.plan_date|interval=P30D))" , lag("COUNT(care_plans.plan_date|interval=P90D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.COUNT(care_plans.plan_date|interval=P90D))" , lag("COUNT(care_plans.plan_id)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.COUNT(care_plans.plan_id))" , lag("COUNT(care_plans.plan_id|interval=P30D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.COUNT(care_plans.plan_id|interval=P30D))" , lag("COUNT(care_plans.plan_id|interval=P90D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.COUNT(care_plans.plan_id|interval=P90D))" , lag("COUNT(care_plans.treatment_type)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.COUNT(care_plans.treatment_type))" , lag("COUNT(care_plans.treatment_type|interval=P30D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.COUNT(care_plans.treatment_type|interval=P30D))" , lag("COUNT(care_plans.treatment_type|interval=P90D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.COUNT(care_plans.treatment_type|interval=P90D))" , lag("MAX(care_plans.ABS(care_plans.cost))", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MAX(care_plans.ABS(care_plans.cost)))" , lag("MAX(care_plans.ABS(care_plans.cost)|interval=P30D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MAX(care_plans.ABS(care_plans.cost)|interval=P30D))" , lag("MAX(care_plans.ABS(care_plans.cost)|interval=P90D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MAX(care_plans.ABS(care_plans.cost)|interval=P90D))" , lag("MAX(care_plans.LAG_1(care_plans.cost))", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MAX(care_plans.LAG_1(care_plans.cost)))" , lag("MAX(care_plans.LAG_1(care_plans.cost)|interval=P30D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MAX(care_plans.LAG_1(care_plans.cost)|interval=P30D))" , lag("MAX(care_plans.LAG_1(care_plans.cost)|interval=P90D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MAX(care_plans.LAG_1(care_plans.cost)|interval=P90D))" , lag("MAX(care_plans.ROLLING_IQR_7(care_plans.cost))", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MAX(care_plans.ROLLING_IQR_7(care_plans.cost)))" , lag("MAX(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MAX(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D))" , lag("MAX(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MAX(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D))" , lag("MAX(care_plans.ROLLING_MEAN_7(care_plans.cost))", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MAX(care_plans.ROLLING_MEAN_7(care_plans.cost)))" , lag("MAX(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MAX(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D))" , lag("MAX(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MAX(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D))" , lag("MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost))", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost)))" , lag("MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D))" , lag("MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D))" , lag("MAX(care_plans.cost)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MAX(care_plans.cost))" , lag("MAX(care_plans.cost|interval=P30D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MAX(care_plans.cost|interval=P30D))" , lag("MAX(care_plans.cost|interval=P90D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MAX(care_plans.cost|interval=P90D))" , lag("MEAN(care_plans.ABS(care_plans.cost))", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MEAN(care_plans.ABS(care_plans.cost)))" , lag("MEAN(care_plans.ABS(care_plans.cost)|interval=P30D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MEAN(care_plans.ABS(care_plans.cost)|interval=P30D))" , lag("MEAN(care_plans.ABS(care_plans.cost)|interval=P90D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MEAN(care_plans.ABS(care_plans.cost)|interval=P90D))" , lag("MEAN(care_plans.LAG_1(care_plans.cost))", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MEAN(care_plans.LAG_1(care_plans.cost)))" , lag("MEAN(care_plans.LAG_1(care_plans.cost)|interval=P30D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MEAN(care_plans.LAG_1(care_plans.cost)|interval=P30D))" , lag("MEAN(care_plans.LAG_1(care_plans.cost)|interval=P90D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MEAN(care_plans.LAG_1(care_plans.cost)|interval=P90D))" , lag("MEAN(care_plans.ROLLING_IQR_7(care_plans.cost))", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MEAN(care_plans.ROLLING_IQR_7(care_plans.cost)))" , lag("MEAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MEAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D))" , lag("MEAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MEAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D))" , lag("MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost))", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost)))" , lag("MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D))" , lag("MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D))" , lag("MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost))", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)))" , lag("MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|inte~f1347cdb", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|inte~f1347cdb)" , lag("MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|inte~f15d471d", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|inte~f15d471d)" , lag("MEAN(care_plans.cost)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MEAN(care_plans.cost))" , lag("MEAN(care_plans.cost|interval=P30D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MEAN(care_plans.cost|interval=P30D))" , lag("MEAN(care_plans.cost|interval=P90D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MEAN(care_plans.cost|interval=P90D))" , lag("MEDIAN(care_plans.ABS(care_plans.cost))", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MEDIAN(care_plans.ABS(care_plans.cost)))" , lag("MEDIAN(care_plans.ABS(care_plans.cost)|interval=P30D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MEDIAN(care_plans.ABS(care_plans.cost)|interval=P30D))" , lag("MEDIAN(care_plans.ABS(care_plans.cost)|interval=P90D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MEDIAN(care_plans.ABS(care_plans.cost)|interval=P90D))" , lag("MEDIAN(care_plans.LAG_1(care_plans.cost))", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MEDIAN(care_plans.LAG_1(care_plans.cost)))" , lag("MEDIAN(care_plans.LAG_1(care_plans.cost)|interval=P30D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MEDIAN(care_plans.LAG_1(care_plans.cost)|interval=P30D))" , lag("MEDIAN(care_plans.LAG_1(care_plans.cost)|interval=P90D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MEDIAN(care_plans.LAG_1(care_plans.cost)|interval=P90D))" , lag("MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost))", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost)))" , lag("MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D))" , lag("MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D))" , lag("MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost))", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost)))" , lag("MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~3455f299", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~3455f299)" , lag("MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~5a5a927f", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~5a5a927f)" , lag("MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost))", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)))" , lag("MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~3923dfc3", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~3923dfc3)" , lag("MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~983564d1", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~983564d1)" , lag("MEDIAN(care_plans.cost)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MEDIAN(care_plans.cost))" , lag("MEDIAN(care_plans.cost|interval=P30D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MEDIAN(care_plans.cost|interval=P30D))" , lag("MEDIAN(care_plans.cost|interval=P90D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MEDIAN(care_plans.cost|interval=P90D))" , lag("MIN(care_plans.ABS(care_plans.cost))", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MIN(care_plans.ABS(care_plans.cost)))" , lag("MIN(care_plans.ABS(care_plans.cost)|interval=P30D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MIN(care_plans.ABS(care_plans.cost)|interval=P30D))" , lag("MIN(care_plans.ABS(care_plans.cost)|interval=P90D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MIN(care_plans.ABS(care_plans.cost)|interval=P90D))" , lag("MIN(care_plans.LAG_1(care_plans.cost))", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MIN(care_plans.LAG_1(care_plans.cost)))" , lag("MIN(care_plans.LAG_1(care_plans.cost)|interval=P30D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MIN(care_plans.LAG_1(care_plans.cost)|interval=P30D))" , lag("MIN(care_plans.LAG_1(care_plans.cost)|interval=P90D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MIN(care_plans.LAG_1(care_plans.cost)|interval=P90D))" , lag("MIN(care_plans.ROLLING_IQR_7(care_plans.cost))", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MIN(care_plans.ROLLING_IQR_7(care_plans.cost)))" , lag("MIN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MIN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D))" , lag("MIN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MIN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D))" , lag("MIN(care_plans.ROLLING_MEAN_7(care_plans.cost))", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MIN(care_plans.ROLLING_MEAN_7(care_plans.cost)))" , lag("MIN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MIN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D))" , lag("MIN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MIN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D))" , lag("MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost))", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)))" , lag("MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D))" , lag("MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D))" , lag("MIN(care_plans.cost)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MIN(care_plans.cost))" , lag("MIN(care_plans.cost|interval=P30D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MIN(care_plans.cost|interval=P30D))" , lag("MIN(care_plans.cost|interval=P90D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.MIN(care_plans.cost|interval=P90D))" , lag("STDDEV(care_plans.ABS(care_plans.cost))", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.STDDEV(care_plans.ABS(care_plans.cost)))" , lag("STDDEV(care_plans.ABS(care_plans.cost)|interval=P30D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.STDDEV(care_plans.ABS(care_plans.cost)|interval=P30D))" , lag("STDDEV(care_plans.ABS(care_plans.cost)|interval=P90D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.STDDEV(care_plans.ABS(care_plans.cost)|interval=P90D))" , lag("STDDEV(care_plans.LAG_1(care_plans.cost))", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.STDDEV(care_plans.LAG_1(care_plans.cost)))" , lag("STDDEV(care_plans.LAG_1(care_plans.cost)|interval=P30D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.STDDEV(care_plans.LAG_1(care_plans.cost)|interval=P30D))" , lag("STDDEV(care_plans.LAG_1(care_plans.cost)|interval=P90D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.STDDEV(care_plans.LAG_1(care_plans.cost)|interval=P90D))" , lag("STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost))", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost)))" , lag("STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D))" , lag("STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D))" , lag("STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost))", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost)))" , lag("STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~96926c25", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~96926c25)" , lag("STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~f96e61ed", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~f96e61ed)" , lag("STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost))", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost)))" , lag("STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~06ee3896", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~06ee3896)" , lag("STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~55d39dc4", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~55d39dc4)" , lag("STDDEV(care_plans.cost)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.STDDEV(care_plans.cost))" , lag("STDDEV(care_plans.cost|interval=P30D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.STDDEV(care_plans.cost|interval=P30D))" , lag("STDDEV(care_plans.cost|interval=P90D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.STDDEV(care_plans.cost|interval=P90D))" , lag("SUM(care_plans.ABS(care_plans.cost))", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.SUM(care_plans.ABS(care_plans.cost)))" , lag("SUM(care_plans.ABS(care_plans.cost)|interval=P30D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.SUM(care_plans.ABS(care_plans.cost)|interval=P30D))" , lag("SUM(care_plans.ABS(care_plans.cost)|interval=P90D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.SUM(care_plans.ABS(care_plans.cost)|interval=P90D))" , lag("SUM(care_plans.LAG_1(care_plans.cost))", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.SUM(care_plans.LAG_1(care_plans.cost)))" , lag("SUM(care_plans.LAG_1(care_plans.cost)|interval=P30D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.SUM(care_plans.LAG_1(care_plans.cost)|interval=P30D))" , lag("SUM(care_plans.LAG_1(care_plans.cost)|interval=P90D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.SUM(care_plans.LAG_1(care_plans.cost)|interval=P90D))" , lag("SUM(care_plans.ROLLING_IQR_7(care_plans.cost))", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.SUM(care_plans.ROLLING_IQR_7(care_plans.cost)))" , lag("SUM(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.SUM(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D))" , lag("SUM(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.SUM(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D))" , lag("SUM(care_plans.ROLLING_MEAN_7(care_plans.cost))", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.SUM(care_plans.ROLLING_MEAN_7(care_plans.cost)))" , lag("SUM(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.SUM(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D))" , lag("SUM(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.SUM(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D))" , lag("SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost))", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost)))" , lag("SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D))" , lag("SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D))" , lag("SUM(care_plans.cost)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.SUM(care_plans.cost))" , lag("SUM(care_plans.cost|interval=P30D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.SUM(care_plans.cost|interval=P30D))" , lag("SUM(care_plans.cost|interval=P90D)", 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.SUM(care_plans.cost|interval=P90D))" , lag(age, 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.age)" , lag(severity_level, 1) over (partition by patient_id order by admission_date) as "LAG_1(patients.severity_level)" , "MAX(care_plans.ABS(care_plans.cost))" as "MAX(care_plans.ABS(care_plans.cost))", "MAX(care_plans.ABS(care_plans.cost)|interval=P30D)" as "MAX(care_plans.ABS(care_plans.cost)|interval=P30D)", "MAX(care_plans.ABS(care_plans.cost)|interval=P90D)" as "MAX(care_plans.ABS(care_plans.cost)|interval=P90D)", "MAX(care_plans.LAG_1(care_plans.cost))" as "MAX(care_plans.LAG_1(care_plans.cost))", "MAX(care_plans.LAG_1(care_plans.cost)|interval=P30D)" as "MAX(care_plans.LAG_1(care_plans.cost)|interval=P30D)", "MAX(care_plans.LAG_1(care_plans.cost)|interval=P90D)" as "MAX(care_plans.LAG_1(care_plans.cost)|interval=P90D)", "MAX(care_plans.ROLLING_IQR_7(care_plans.cost))" as "MAX(care_plans.ROLLING_IQR_7(care_plans.cost))", "MAX(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)" as "MAX(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)", "MAX(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)" as "MAX(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)", "MAX(care_plans.ROLLING_MEAN_7(care_plans.cost))" as "MAX(care_plans.ROLLING_MEAN_7(care_plans.cost))", "MAX(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D)" as "MAX(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D)", "MAX(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D)" as "MAX(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D)", "MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost))" as "MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost))", "MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D)" as "MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D)", "MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D)" as "MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D)", "MAX(care_plans.cost)" as "MAX(care_plans.cost)", "MAX(care_plans.cost|interval=P30D)" as "MAX(care_plans.cost|interval=P30D)", "MAX(care_plans.cost|interval=P90D)" as "MAX(care_plans.cost|interval=P90D)", "MEAN(care_plans.ABS(care_plans.cost))" as "MEAN(care_plans.ABS(care_plans.cost))", "MEAN(care_plans.ABS(care_plans.cost)|interval=P30D)" as "MEAN(care_plans.ABS(care_plans.cost)|interval=P30D)", "MEAN(care_plans.ABS(care_plans.cost)|interval=P90D)" as "MEAN(care_plans.ABS(care_plans.cost)|interval=P90D)", "MEAN(care_plans.LAG_1(care_plans.cost))" as "MEAN(care_plans.LAG_1(care_plans.cost))", "MEAN(care_plans.LAG_1(care_plans.cost)|interval=P30D)" as "MEAN(care_plans.LAG_1(care_plans.cost)|interval=P30D)", "MEAN(care_plans.LAG_1(care_plans.cost)|interval=P90D)" as "MEAN(care_plans.LAG_1(care_plans.cost)|interval=P90D)", "MEAN(care_plans.ROLLING_IQR_7(care_plans.cost))" as "MEAN(care_plans.ROLLING_IQR_7(care_plans.cost))", "MEAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)" as "MEAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)", "MEAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)" as "MEAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)", "MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost))" as "MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost))", "MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D)" as "MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D)", "MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D)" as "MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D)", "MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost))" as "MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost))", "MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|inte~f1347cdb" as "MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|inte~f1347cdb", "MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|inte~f15d471d" as "MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|inte~f15d471d", "MEAN(care_plans.cost)" as "MEAN(care_plans.cost)", "MEAN(care_plans.cost|interval=P30D)" as "MEAN(care_plans.cost|interval=P30D)", "MEAN(care_plans.cost|interval=P90D)" as "MEAN(care_plans.cost|interval=P90D)", "MEDIAN(care_plans.ABS(care_plans.cost))" as "MEDIAN(care_plans.ABS(care_plans.cost))", "MEDIAN(care_plans.ABS(care_plans.cost)|interval=P30D)" as "MEDIAN(care_plans.ABS(care_plans.cost)|interval=P30D)", "MEDIAN(care_plans.ABS(care_plans.cost)|interval=P90D)" as "MEDIAN(care_plans.ABS(care_plans.cost)|interval=P90D)", "MEDIAN(care_plans.LAG_1(care_plans.cost))" as "MEDIAN(care_plans.LAG_1(care_plans.cost))", "MEDIAN(care_plans.LAG_1(care_plans.cost)|interval=P30D)" as "MEDIAN(care_plans.LAG_1(care_plans.cost)|interval=P30D)", "MEDIAN(care_plans.LAG_1(care_plans.cost)|interval=P90D)" as "MEDIAN(care_plans.LAG_1(care_plans.cost)|interval=P90D)", "MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost))" as "MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost))", "MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)" as "MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)", "MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)" as "MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)", "MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost))" as "MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost))", "MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~3455f299" as "MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~3455f299", "MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~5a5a927f" as "MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~5a5a927f", "MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost))" as "MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost))", "MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~3923dfc3" as "MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~3923dfc3", "MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~983564d1" as "MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~983564d1", "MEDIAN(care_plans.cost)" as "MEDIAN(care_plans.cost)", "MEDIAN(care_plans.cost|interval=P30D)" as "MEDIAN(care_plans.cost|interval=P30D)", "MEDIAN(care_plans.cost|interval=P90D)" as "MEDIAN(care_plans.cost|interval=P90D)", "MIN(care_plans.ABS(care_plans.cost))" as "MIN(care_plans.ABS(care_plans.cost))", "MIN(care_plans.ABS(care_plans.cost)|interval=P30D)" as "MIN(care_plans.ABS(care_plans.cost)|interval=P30D)", "MIN(care_plans.ABS(care_plans.cost)|interval=P90D)" as "MIN(care_plans.ABS(care_plans.cost)|interval=P90D)", "MIN(care_plans.LAG_1(care_plans.cost))" as "MIN(care_plans.LAG_1(care_plans.cost))", "MIN(care_plans.LAG_1(care_plans.cost)|interval=P30D)" as "MIN(care_plans.LAG_1(care_plans.cost)|interval=P30D)", "MIN(care_plans.LAG_1(care_plans.cost)|interval=P90D)" as "MIN(care_plans.LAG_1(care_plans.cost)|interval=P90D)", "MIN(care_plans.ROLLING_IQR_7(care_plans.cost))" as "MIN(care_plans.ROLLING_IQR_7(care_plans.cost))", "MIN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)" as "MIN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)", "MIN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)" as "MIN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)", "MIN(care_plans.ROLLING_MEAN_7(care_plans.cost))" as "MIN(care_plans.ROLLING_MEAN_7(care_plans.cost))", "MIN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D)" as "MIN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D)", "MIN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D)" as "MIN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D)", "MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost))" as "MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost))", "MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D)" as "MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D)", "MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D)" as "MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D)", "MIN(care_plans.cost)" as "MIN(care_plans.cost)", "MIN(care_plans.cost|interval=P30D)" as "MIN(care_plans.cost|interval=P30D)", "MIN(care_plans.cost|interval=P90D)" as "MIN(care_plans.cost|interval=P90D)", ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."COUNT(care_plans.LAG_1(care_plans.treatment_type))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."COUNT(care_plans.LAG_1(care_plans.treatment_type))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.COUNT(care_plans.LAG_1(care_plans.treatment_type)))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."COUNT(care_plans.LAG_1(care_plans.treatment_type)|inte~4f9badff" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."COUNT(care_plans.LAG_1(care_plans.treatment_type)|inte~4f9badff" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.COUNT(care_plans.LAG_1(care_plans.treatment_type)|inte~4f9badff)" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."COUNT(care_plans.LAG_1(care_plans.treatment_type)|inte~d7382445" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."COUNT(care_plans.LAG_1(care_plans.treatment_type)|inte~d7382445" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.COUNT(care_plans.LAG_1(care_plans.treatment_type)|inte~d7382445)" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."COUNT(care_plans.plan_date)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."COUNT(care_plans.plan_date)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.COUNT(care_plans.plan_date))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."COUNT(care_plans.plan_date|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."COUNT(care_plans.plan_date|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.COUNT(care_plans.plan_date|interval=P30D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."COUNT(care_plans.plan_date|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."COUNT(care_plans.plan_date|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.COUNT(care_plans.plan_date|interval=P90D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."COUNT(care_plans.plan_id)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."COUNT(care_plans.plan_id)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.COUNT(care_plans.plan_id))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."COUNT(care_plans.plan_id|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."COUNT(care_plans.plan_id|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.COUNT(care_plans.plan_id|interval=P30D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."COUNT(care_plans.plan_id|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."COUNT(care_plans.plan_id|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.COUNT(care_plans.plan_id|interval=P90D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."COUNT(care_plans.treatment_type)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."COUNT(care_plans.treatment_type)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.COUNT(care_plans.treatment_type))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."COUNT(care_plans.treatment_type|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."COUNT(care_plans.treatment_type|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.COUNT(care_plans.treatment_type|interval=P30D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."COUNT(care_plans.treatment_type|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."COUNT(care_plans.treatment_type|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.COUNT(care_plans.treatment_type|interval=P90D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MAX(care_plans.ABS(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MAX(care_plans.ABS(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MAX(care_plans.ABS(care_plans.cost)))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MAX(care_plans.ABS(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MAX(care_plans.ABS(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MAX(care_plans.ABS(care_plans.cost)|interval=P30D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MAX(care_plans.ABS(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MAX(care_plans.ABS(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MAX(care_plans.ABS(care_plans.cost)|interval=P90D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MAX(care_plans.LAG_1(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MAX(care_plans.LAG_1(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MAX(care_plans.LAG_1(care_plans.cost)))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MAX(care_plans.LAG_1(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MAX(care_plans.LAG_1(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MAX(care_plans.LAG_1(care_plans.cost)|interval=P30D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MAX(care_plans.LAG_1(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MAX(care_plans.LAG_1(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MAX(care_plans.LAG_1(care_plans.cost)|interval=P90D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MAX(care_plans.ROLLING_IQR_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MAX(care_plans.ROLLING_IQR_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MAX(care_plans.ROLLING_IQR_7(care_plans.cost)))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MAX(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MAX(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MAX(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MAX(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MAX(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MAX(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MAX(care_plans.ROLLING_MEAN_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MAX(care_plans.ROLLING_MEAN_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MAX(care_plans.ROLLING_MEAN_7(care_plans.cost)))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MAX(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MAX(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MAX(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MAX(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MAX(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MAX(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost)))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MAX(care_plans.cost)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MAX(care_plans.cost)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MAX(care_plans.cost))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MAX(care_plans.cost|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MAX(care_plans.cost|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MAX(care_plans.cost|interval=P30D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MAX(care_plans.cost|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MAX(care_plans.cost|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MAX(care_plans.cost|interval=P90D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.ABS(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.ABS(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MEAN(care_plans.ABS(care_plans.cost)))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.ABS(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.ABS(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MEAN(care_plans.ABS(care_plans.cost)|interval=P30D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.ABS(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.ABS(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MEAN(care_plans.ABS(care_plans.cost)|interval=P90D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.LAG_1(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.LAG_1(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MEAN(care_plans.LAG_1(care_plans.cost)))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.LAG_1(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.LAG_1(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MEAN(care_plans.LAG_1(care_plans.cost)|interval=P30D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.LAG_1(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.LAG_1(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MEAN(care_plans.LAG_1(care_plans.cost)|interval=P90D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.ROLLING_IQR_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.ROLLING_IQR_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MEAN(care_plans.ROLLING_IQR_7(care_plans.cost)))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MEAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MEAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost)))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|inte~f1347cdb" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|inte~f1347cdb" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|inte~f1347cdb)" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|inte~f15d471d" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|inte~f15d471d" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|inte~f15d471d)" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.cost)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.cost)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MEAN(care_plans.cost))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.cost|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.cost|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MEAN(care_plans.cost|interval=P30D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.cost|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.cost|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MEAN(care_plans.cost|interval=P90D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.ABS(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.ABS(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MEDIAN(care_plans.ABS(care_plans.cost)))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.ABS(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.ABS(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MEDIAN(care_plans.ABS(care_plans.cost)|interval=P30D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.ABS(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.ABS(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MEDIAN(care_plans.ABS(care_plans.cost)|interval=P90D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.LAG_1(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.LAG_1(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MEDIAN(care_plans.LAG_1(care_plans.cost)))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.LAG_1(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.LAG_1(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MEDIAN(care_plans.LAG_1(care_plans.cost)|interval=P30D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.LAG_1(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.LAG_1(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MEDIAN(care_plans.LAG_1(care_plans.cost)|interval=P90D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost)))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost)))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~3455f299" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~3455f299" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~3455f299)" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~5a5a927f" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~5a5a927f" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~5a5a927f)" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~3923dfc3" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~3923dfc3" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~3923dfc3)" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~983564d1" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~983564d1" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~983564d1)" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.cost)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.cost)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MEDIAN(care_plans.cost))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.cost|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.cost|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MEDIAN(care_plans.cost|interval=P30D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.cost|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.cost|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MEDIAN(care_plans.cost|interval=P90D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MIN(care_plans.ABS(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MIN(care_plans.ABS(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MIN(care_plans.ABS(care_plans.cost)))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MIN(care_plans.ABS(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MIN(care_plans.ABS(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MIN(care_plans.ABS(care_plans.cost)|interval=P30D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MIN(care_plans.ABS(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MIN(care_plans.ABS(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MIN(care_plans.ABS(care_plans.cost)|interval=P90D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MIN(care_plans.LAG_1(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MIN(care_plans.LAG_1(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MIN(care_plans.LAG_1(care_plans.cost)))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MIN(care_plans.LAG_1(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MIN(care_plans.LAG_1(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MIN(care_plans.LAG_1(care_plans.cost)|interval=P30D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MIN(care_plans.LAG_1(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MIN(care_plans.LAG_1(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MIN(care_plans.LAG_1(care_plans.cost)|interval=P90D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MIN(care_plans.ROLLING_IQR_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MIN(care_plans.ROLLING_IQR_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MIN(care_plans.ROLLING_IQR_7(care_plans.cost)))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MIN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MIN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MIN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MIN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MIN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MIN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MIN(care_plans.ROLLING_MEAN_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MIN(care_plans.ROLLING_MEAN_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MIN(care_plans.ROLLING_MEAN_7(care_plans.cost)))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MIN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MIN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MIN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MIN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MIN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MIN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MIN(care_plans.cost)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MIN(care_plans.cost)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MIN(care_plans.cost))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MIN(care_plans.cost|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MIN(care_plans.cost|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MIN(care_plans.cost|interval=P30D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."MIN(care_plans.cost|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."MIN(care_plans.cost|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.MIN(care_plans.cost|interval=P90D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.ABS(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.ABS(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.STDDEV(care_plans.ABS(care_plans.cost)))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.ABS(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.ABS(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.STDDEV(care_plans.ABS(care_plans.cost)|interval=P30D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.ABS(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.ABS(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.STDDEV(care_plans.ABS(care_plans.cost)|interval=P90D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.LAG_1(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.LAG_1(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.STDDEV(care_plans.LAG_1(care_plans.cost)))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.LAG_1(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.LAG_1(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.STDDEV(care_plans.LAG_1(care_plans.cost)|interval=P30D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.LAG_1(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.LAG_1(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.STDDEV(care_plans.LAG_1(care_plans.cost)|interval=P90D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost)))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost)))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~96926c25" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~96926c25" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~96926c25)" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~f96e61ed" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~f96e61ed" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~f96e61ed)" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost)))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~06ee3896" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~06ee3896" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~06ee3896)" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~55d39dc4" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~55d39dc4" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~55d39dc4)" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.cost)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.cost)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.STDDEV(care_plans.cost))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.cost|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.cost|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.STDDEV(care_plans.cost|interval=P30D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.cost|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.cost|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.STDDEV(care_plans.cost|interval=P90D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."SUM(care_plans.ABS(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."SUM(care_plans.ABS(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.SUM(care_plans.ABS(care_plans.cost)))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."SUM(care_plans.ABS(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."SUM(care_plans.ABS(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.SUM(care_plans.ABS(care_plans.cost)|interval=P30D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."SUM(care_plans.ABS(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."SUM(care_plans.ABS(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.SUM(care_plans.ABS(care_plans.cost)|interval=P90D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."SUM(care_plans.LAG_1(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."SUM(care_plans.LAG_1(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.SUM(care_plans.LAG_1(care_plans.cost)))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."SUM(care_plans.LAG_1(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."SUM(care_plans.LAG_1(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.SUM(care_plans.LAG_1(care_plans.cost)|interval=P30D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."SUM(care_plans.LAG_1(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."SUM(care_plans.LAG_1(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.SUM(care_plans.LAG_1(care_plans.cost)|interval=P90D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."SUM(care_plans.ROLLING_IQR_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."SUM(care_plans.ROLLING_IQR_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.SUM(care_plans.ROLLING_IQR_7(care_plans.cost)))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."SUM(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."SUM(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.SUM(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."SUM(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."SUM(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.SUM(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."SUM(care_plans.ROLLING_MEAN_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."SUM(care_plans.ROLLING_MEAN_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.SUM(care_plans.ROLLING_MEAN_7(care_plans.cost)))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."SUM(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."SUM(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.SUM(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."SUM(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."SUM(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.SUM(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost)))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."SUM(care_plans.cost)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."SUM(care_plans.cost)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.SUM(care_plans.cost))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."SUM(care_plans.cost|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."SUM(care_plans.cost|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.SUM(care_plans.cost|interval=P30D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth."SUM(care_plans.cost|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth."SUM(care_plans.cost|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.SUM(care_plans.cost|interval=P90D))" , ((select percentile_cont(0.75) within group (order by _w.v) from (select patients_synth.age as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) - ((select percentile_cont(0.25) within group (order by _w.v) from (select patients_synth.age as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w)) as "ROLLING_IQR_7(patients.age)" , avg("COUNT(care_plans.LAG_1(care_plans.treatment_type))") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.COUNT(care_plans.LAG_1(care_plans.treatment_type)))" , avg("COUNT(care_plans.LAG_1(care_plans.treatment_type)|inte~4f9badff") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.COUNT(care_plans.LAG_1(care_plans.treatment_type)|inte~4f9badff)" , avg("COUNT(care_plans.LAG_1(care_plans.treatment_type)|inte~d7382445") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.COUNT(care_plans.LAG_1(care_plans.treatment_type)|inte~d7382445)" , avg("COUNT(care_plans.plan_date)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.COUNT(care_plans.plan_date))" , avg("COUNT(care_plans.plan_date|interval=P30D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.COUNT(care_plans.plan_date|interval=P30D))" , avg("COUNT(care_plans.plan_date|interval=P90D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.COUNT(care_plans.plan_date|interval=P90D))" , avg("COUNT(care_plans.plan_id)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.COUNT(care_plans.plan_id))" , avg("COUNT(care_plans.plan_id|interval=P30D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.COUNT(care_plans.plan_id|interval=P30D))" , avg("COUNT(care_plans.plan_id|interval=P90D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.COUNT(care_plans.plan_id|interval=P90D))" , avg("COUNT(care_plans.treatment_type)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.COUNT(care_plans.treatment_type))" , avg("COUNT(care_plans.treatment_type|interval=P30D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.COUNT(care_plans.treatment_type|interval=P30D))" , avg("COUNT(care_plans.treatment_type|interval=P90D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.COUNT(care_plans.treatment_type|interval=P90D))" , avg("MAX(care_plans.ABS(care_plans.cost))") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MAX(care_plans.ABS(care_plans.cost)))" , avg("MAX(care_plans.ABS(care_plans.cost)|interval=P30D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MAX(care_plans.ABS(care_plans.cost)|interval=P30D))" , avg("MAX(care_plans.ABS(care_plans.cost)|interval=P90D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MAX(care_plans.ABS(care_plans.cost)|interval=P90D))" , avg("MAX(care_plans.LAG_1(care_plans.cost))") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MAX(care_plans.LAG_1(care_plans.cost)))" , avg("MAX(care_plans.LAG_1(care_plans.cost)|interval=P30D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MAX(care_plans.LAG_1(care_plans.cost)|interval=P30D))" , avg("MAX(care_plans.LAG_1(care_plans.cost)|interval=P90D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MAX(care_plans.LAG_1(care_plans.cost)|interval=P90D))" , avg("MAX(care_plans.ROLLING_IQR_7(care_plans.cost))") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MAX(care_plans.ROLLING_IQR_7(care_plans.cost)))" , avg("MAX(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MAX(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D))" , avg("MAX(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MAX(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D))" , avg("MAX(care_plans.ROLLING_MEAN_7(care_plans.cost))") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MAX(care_plans.ROLLING_MEAN_7(care_plans.cost)))" , avg("MAX(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MAX(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D))" , avg("MAX(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MAX(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D))" , avg("MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost))") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost)))" , avg("MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D))" , avg("MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D))" , avg("MAX(care_plans.cost)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MAX(care_plans.cost))" , avg("MAX(care_plans.cost|interval=P30D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MAX(care_plans.cost|interval=P30D))" , avg("MAX(care_plans.cost|interval=P90D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MAX(care_plans.cost|interval=P90D))" , avg("MEAN(care_plans.ABS(care_plans.cost))") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MEAN(care_plans.ABS(care_plans.cost)))" , avg("MEAN(care_plans.ABS(care_plans.cost)|interval=P30D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MEAN(care_plans.ABS(care_plans.cost)|interval=P30D))" , avg("MEAN(care_plans.ABS(care_plans.cost)|interval=P90D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MEAN(care_plans.ABS(care_plans.cost)|interval=P90D))" , avg("MEAN(care_plans.LAG_1(care_plans.cost))") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MEAN(care_plans.LAG_1(care_plans.cost)))" , avg("MEAN(care_plans.LAG_1(care_plans.cost)|interval=P30D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MEAN(care_plans.LAG_1(care_plans.cost)|interval=P30D))" , avg("MEAN(care_plans.LAG_1(care_plans.cost)|interval=P90D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MEAN(care_plans.LAG_1(care_plans.cost)|interval=P90D))" , avg("MEAN(care_plans.ROLLING_IQR_7(care_plans.cost))") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MEAN(care_plans.ROLLING_IQR_7(care_plans.cost)))" , avg("MEAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MEAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D))" , avg("MEAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MEAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D))" , avg("MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost))") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost)))" , avg("MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D))" , avg("MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D))" , avg("MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost))") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)))" , avg("MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|inte~f1347cdb") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|inte~f1347cdb)" , avg("MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|inte~f15d471d") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|inte~f15d471d)" , avg("MEAN(care_plans.cost)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MEAN(care_plans.cost))" , avg("MEAN(care_plans.cost|interval=P30D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MEAN(care_plans.cost|interval=P30D))" , avg("MEAN(care_plans.cost|interval=P90D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MEAN(care_plans.cost|interval=P90D))" , avg("MEDIAN(care_plans.ABS(care_plans.cost))") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MEDIAN(care_plans.ABS(care_plans.cost)))" , avg("MEDIAN(care_plans.ABS(care_plans.cost)|interval=P30D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MEDIAN(care_plans.ABS(care_plans.cost)|interval=P30D))" , avg("MEDIAN(care_plans.ABS(care_plans.cost)|interval=P90D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MEDIAN(care_plans.ABS(care_plans.cost)|interval=P90D))" , avg("MEDIAN(care_plans.LAG_1(care_plans.cost))") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MEDIAN(care_plans.LAG_1(care_plans.cost)))" , avg("MEDIAN(care_plans.LAG_1(care_plans.cost)|interval=P30D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MEDIAN(care_plans.LAG_1(care_plans.cost)|interval=P30D))" , avg("MEDIAN(care_plans.LAG_1(care_plans.cost)|interval=P90D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MEDIAN(care_plans.LAG_1(care_plans.cost)|interval=P90D))" , avg("MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost))") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost)))" , avg("MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D))" , avg("MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D))" , avg("MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost))") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost)))" , avg("MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~3455f299") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~3455f299)" , avg("MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~5a5a927f") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~5a5a927f)" , avg("MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost))") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)))" , avg("MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~3923dfc3") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~3923dfc3)" , avg("MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~983564d1") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~983564d1)" , avg("MEDIAN(care_plans.cost)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MEDIAN(care_plans.cost))" , avg("MEDIAN(care_plans.cost|interval=P30D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MEDIAN(care_plans.cost|interval=P30D))" , avg("MEDIAN(care_plans.cost|interval=P90D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MEDIAN(care_plans.cost|interval=P90D))" , avg("MIN(care_plans.ABS(care_plans.cost))") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MIN(care_plans.ABS(care_plans.cost)))" , avg("MIN(care_plans.ABS(care_plans.cost)|interval=P30D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MIN(care_plans.ABS(care_plans.cost)|interval=P30D))" , avg("MIN(care_plans.ABS(care_plans.cost)|interval=P90D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MIN(care_plans.ABS(care_plans.cost)|interval=P90D))" , avg("MIN(care_plans.LAG_1(care_plans.cost))") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MIN(care_plans.LAG_1(care_plans.cost)))" , avg("MIN(care_plans.LAG_1(care_plans.cost)|interval=P30D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MIN(care_plans.LAG_1(care_plans.cost)|interval=P30D))" , avg("MIN(care_plans.LAG_1(care_plans.cost)|interval=P90D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MIN(care_plans.LAG_1(care_plans.cost)|interval=P90D))" , avg("MIN(care_plans.ROLLING_IQR_7(care_plans.cost))") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MIN(care_plans.ROLLING_IQR_7(care_plans.cost)))" , avg("MIN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MIN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D))" , avg("MIN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MIN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D))" , avg("MIN(care_plans.ROLLING_MEAN_7(care_plans.cost))") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MIN(care_plans.ROLLING_MEAN_7(care_plans.cost)))" , avg("MIN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MIN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D))" , avg("MIN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MIN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D))" , avg("MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost))") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)))" , avg("MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D))" , avg("MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D))" , avg("MIN(care_plans.cost)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MIN(care_plans.cost))" , avg("MIN(care_plans.cost|interval=P30D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MIN(care_plans.cost|interval=P30D))" , avg("MIN(care_plans.cost|interval=P90D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.MIN(care_plans.cost|interval=P90D))" , avg("STDDEV(care_plans.ABS(care_plans.cost))") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.STDDEV(care_plans.ABS(care_plans.cost)))" , avg("STDDEV(care_plans.ABS(care_plans.cost)|interval=P30D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.STDDEV(care_plans.ABS(care_plans.cost)|interval=P30D))" , avg("STDDEV(care_plans.ABS(care_plans.cost)|interval=P90D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.STDDEV(care_plans.ABS(care_plans.cost)|interval=P90D))" , avg("STDDEV(care_plans.LAG_1(care_plans.cost))") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.STDDEV(care_plans.LAG_1(care_plans.cost)))" , avg("STDDEV(care_plans.LAG_1(care_plans.cost)|interval=P30D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.STDDEV(care_plans.LAG_1(care_plans.cost)|interval=P30D))" , avg("STDDEV(care_plans.LAG_1(care_plans.cost)|interval=P90D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.STDDEV(care_plans.LAG_1(care_plans.cost)|interval=P90D))" , avg("STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost))") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost)))" , avg("STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D))" , avg("STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D))" , avg("STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost))") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost)))" , avg("STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~96926c25") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~96926c25)" , avg("STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~f96e61ed") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~f96e61ed)" , avg("STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost))") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost)))" , avg("STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~06ee3896") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~06ee3896)" , avg("STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~55d39dc4") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~55d39dc4)" , avg("STDDEV(care_plans.cost)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.STDDEV(care_plans.cost))" , avg("STDDEV(care_plans.cost|interval=P30D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.STDDEV(care_plans.cost|interval=P30D))" , avg("STDDEV(care_plans.cost|interval=P90D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.STDDEV(care_plans.cost|interval=P90D))" , avg("SUM(care_plans.ABS(care_plans.cost))") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.SUM(care_plans.ABS(care_plans.cost)))" , avg("SUM(care_plans.ABS(care_plans.cost)|interval=P30D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.SUM(care_plans.ABS(care_plans.cost)|interval=P30D))" , avg("SUM(care_plans.ABS(care_plans.cost)|interval=P90D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.SUM(care_plans.ABS(care_plans.cost)|interval=P90D))" , avg("SUM(care_plans.LAG_1(care_plans.cost))") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.SUM(care_plans.LAG_1(care_plans.cost)))" , avg("SUM(care_plans.LAG_1(care_plans.cost)|interval=P30D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.SUM(care_plans.LAG_1(care_plans.cost)|interval=P30D))" , avg("SUM(care_plans.LAG_1(care_plans.cost)|interval=P90D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.SUM(care_plans.LAG_1(care_plans.cost)|interval=P90D))" , avg("SUM(care_plans.ROLLING_IQR_7(care_plans.cost))") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.SUM(care_plans.ROLLING_IQR_7(care_plans.cost)))" , avg("SUM(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.SUM(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D))" , avg("SUM(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.SUM(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D))" , avg("SUM(care_plans.ROLLING_MEAN_7(care_plans.cost))") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.SUM(care_plans.ROLLING_MEAN_7(care_plans.cost)))" , avg("SUM(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.SUM(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D))" , avg("SUM(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.SUM(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D))" , avg("SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost))") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost)))" , avg("SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D))" , avg("SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D))" , avg("SUM(care_plans.cost)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.SUM(care_plans.cost))" , avg("SUM(care_plans.cost|interval=P30D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.SUM(care_plans.cost|interval=P30D))" , avg("SUM(care_plans.cost|interval=P90D)") over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.SUM(care_plans.cost|interval=P90D))" , avg(age) over (partition by patient_id order by admission_date rows between 6 preceding and current row) as "ROLLING_MEAN_7(patients.age)" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."COUNT(care_plans.LAG_1(care_plans.treatment_type))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.COUNT(care_plans.LAG_1(care_plans.treatment_type)))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."COUNT(care_plans.LAG_1(care_plans.treatment_type)|inte~4f9badff" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.COUNT(care_plans.LAG_1(care_plans.treatment_type)|inte~4f9badff)" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."COUNT(care_plans.LAG_1(care_plans.treatment_type)|inte~d7382445" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.COUNT(care_plans.LAG_1(care_plans.treatment_type)|inte~d7382445)" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."COUNT(care_plans.plan_date)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.COUNT(care_plans.plan_date))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."COUNT(care_plans.plan_date|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.COUNT(care_plans.plan_date|interval=P30D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."COUNT(care_plans.plan_date|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.COUNT(care_plans.plan_date|interval=P90D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."COUNT(care_plans.plan_id)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.COUNT(care_plans.plan_id))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."COUNT(care_plans.plan_id|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.COUNT(care_plans.plan_id|interval=P30D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."COUNT(care_plans.plan_id|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.COUNT(care_plans.plan_id|interval=P90D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."COUNT(care_plans.treatment_type)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.COUNT(care_plans.treatment_type))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."COUNT(care_plans.treatment_type|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.COUNT(care_plans.treatment_type|interval=P30D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."COUNT(care_plans.treatment_type|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.COUNT(care_plans.treatment_type|interval=P90D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MAX(care_plans.ABS(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MAX(care_plans.ABS(care_plans.cost)))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MAX(care_plans.ABS(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MAX(care_plans.ABS(care_plans.cost)|interval=P30D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MAX(care_plans.ABS(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MAX(care_plans.ABS(care_plans.cost)|interval=P90D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MAX(care_plans.LAG_1(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MAX(care_plans.LAG_1(care_plans.cost)))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MAX(care_plans.LAG_1(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MAX(care_plans.LAG_1(care_plans.cost)|interval=P30D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MAX(care_plans.LAG_1(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MAX(care_plans.LAG_1(care_plans.cost)|interval=P90D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MAX(care_plans.ROLLING_IQR_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MAX(care_plans.ROLLING_IQR_7(care_plans.cost)))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MAX(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MAX(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MAX(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MAX(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MAX(care_plans.ROLLING_MEAN_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MAX(care_plans.ROLLING_MEAN_7(care_plans.cost)))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MAX(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MAX(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MAX(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MAX(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost)))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MAX(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MAX(care_plans.cost)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MAX(care_plans.cost))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MAX(care_plans.cost|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MAX(care_plans.cost|interval=P30D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MAX(care_plans.cost|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MAX(care_plans.cost|interval=P90D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.ABS(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MEAN(care_plans.ABS(care_plans.cost)))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.ABS(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MEAN(care_plans.ABS(care_plans.cost)|interval=P30D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.ABS(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MEAN(care_plans.ABS(care_plans.cost)|interval=P90D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.LAG_1(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MEAN(care_plans.LAG_1(care_plans.cost)))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.LAG_1(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MEAN(care_plans.LAG_1(care_plans.cost)|interval=P30D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.LAG_1(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MEAN(care_plans.LAG_1(care_plans.cost)|interval=P90D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.ROLLING_IQR_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MEAN(care_plans.ROLLING_IQR_7(care_plans.cost)))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MEAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MEAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost)))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MEAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|inte~f1347cdb" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|inte~f1347cdb)" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|inte~f15d471d" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MEAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|inte~f15d471d)" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.cost)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MEAN(care_plans.cost))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.cost|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MEAN(care_plans.cost|interval=P30D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MEAN(care_plans.cost|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MEAN(care_plans.cost|interval=P90D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.ABS(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MEDIAN(care_plans.ABS(care_plans.cost)))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.ABS(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MEDIAN(care_plans.ABS(care_plans.cost)|interval=P30D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.ABS(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MEDIAN(care_plans.ABS(care_plans.cost)|interval=P90D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.LAG_1(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MEDIAN(care_plans.LAG_1(care_plans.cost)))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.LAG_1(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MEDIAN(care_plans.LAG_1(care_plans.cost)|interval=P30D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.LAG_1(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MEDIAN(care_plans.LAG_1(care_plans.cost)|interval=P90D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost)))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MEDIAN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost)))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~3455f299" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~3455f299)" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~5a5a927f" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MEDIAN(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~5a5a927f)" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~3923dfc3" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~3923dfc3)" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~983564d1" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MEDIAN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~983564d1)" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.cost)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MEDIAN(care_plans.cost))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.cost|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MEDIAN(care_plans.cost|interval=P30D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MEDIAN(care_plans.cost|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MEDIAN(care_plans.cost|interval=P90D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MIN(care_plans.ABS(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MIN(care_plans.ABS(care_plans.cost)))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MIN(care_plans.ABS(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MIN(care_plans.ABS(care_plans.cost)|interval=P30D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MIN(care_plans.ABS(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MIN(care_plans.ABS(care_plans.cost)|interval=P90D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MIN(care_plans.LAG_1(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MIN(care_plans.LAG_1(care_plans.cost)))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MIN(care_plans.LAG_1(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MIN(care_plans.LAG_1(care_plans.cost)|interval=P30D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MIN(care_plans.LAG_1(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MIN(care_plans.LAG_1(care_plans.cost)|interval=P90D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MIN(care_plans.ROLLING_IQR_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MIN(care_plans.ROLLING_IQR_7(care_plans.cost)))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MIN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MIN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MIN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MIN(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MIN(care_plans.ROLLING_MEAN_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MIN(care_plans.ROLLING_MEAN_7(care_plans.cost)))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MIN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MIN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MIN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MIN(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MIN(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MIN(care_plans.cost)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MIN(care_plans.cost))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MIN(care_plans.cost|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MIN(care_plans.cost|interval=P30D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."MIN(care_plans.cost|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.MIN(care_plans.cost|interval=P90D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.ABS(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.STDDEV(care_plans.ABS(care_plans.cost)))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.ABS(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.STDDEV(care_plans.ABS(care_plans.cost)|interval=P30D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.ABS(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.STDDEV(care_plans.ABS(care_plans.cost)|interval=P90D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.LAG_1(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.STDDEV(care_plans.LAG_1(care_plans.cost)))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.LAG_1(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.STDDEV(care_plans.LAG_1(care_plans.cost)|interval=P30D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.LAG_1(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.STDDEV(care_plans.LAG_1(care_plans.cost)|interval=P90D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost)))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost)))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~96926c25" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~96926c25)" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~f96e61ed" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~f96e61ed)" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost)))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~06ee3896" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~06ee3896)" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~55d39dc4" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~55d39dc4)" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.cost)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.STDDEV(care_plans.cost))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.cost|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.STDDEV(care_plans.cost|interval=P30D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."STDDEV(care_plans.cost|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.STDDEV(care_plans.cost|interval=P90D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."SUM(care_plans.ABS(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.SUM(care_plans.ABS(care_plans.cost)))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."SUM(care_plans.ABS(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.SUM(care_plans.ABS(care_plans.cost)|interval=P30D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."SUM(care_plans.ABS(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.SUM(care_plans.ABS(care_plans.cost)|interval=P90D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."SUM(care_plans.LAG_1(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.SUM(care_plans.LAG_1(care_plans.cost)))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."SUM(care_plans.LAG_1(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.SUM(care_plans.LAG_1(care_plans.cost)|interval=P30D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."SUM(care_plans.LAG_1(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.SUM(care_plans.LAG_1(care_plans.cost)|interval=P90D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."SUM(care_plans.ROLLING_IQR_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.SUM(care_plans.ROLLING_IQR_7(care_plans.cost)))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."SUM(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.SUM(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."SUM(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.SUM(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."SUM(care_plans.ROLLING_MEAN_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.SUM(care_plans.ROLLING_MEAN_7(care_plans.cost)))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."SUM(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.SUM(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."SUM(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.SUM(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost))" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost)))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."SUM(care_plans.cost)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.SUM(care_plans.cost))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."SUM(care_plans.cost|interval=P30D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.SUM(care_plans.cost|interval=P30D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth."SUM(care_plans.cost|interval=P90D)" as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.SUM(care_plans.cost|interval=P90D))" , (select percentile_cont(0.5) within group (order by _w.v) from (select patients_synth.age as v from patients_synth where patients_synth.patient_id = _ego.patient_id and patients_synth.admission_date <= _ego.admission_date order by patients_synth.admission_date desc limit 7) _w) as "ROLLING_MEDIAN_7(patients.age)" , "STDDEV(care_plans.ABS(care_plans.cost))" as "STDDEV(care_plans.ABS(care_plans.cost))", "STDDEV(care_plans.ABS(care_plans.cost)|interval=P30D)" as "STDDEV(care_plans.ABS(care_plans.cost)|interval=P30D)", "STDDEV(care_plans.ABS(care_plans.cost)|interval=P90D)" as "STDDEV(care_plans.ABS(care_plans.cost)|interval=P90D)", "STDDEV(care_plans.LAG_1(care_plans.cost))" as "STDDEV(care_plans.LAG_1(care_plans.cost))", "STDDEV(care_plans.LAG_1(care_plans.cost)|interval=P30D)" as "STDDEV(care_plans.LAG_1(care_plans.cost)|interval=P30D)", "STDDEV(care_plans.LAG_1(care_plans.cost)|interval=P90D)" as "STDDEV(care_plans.LAG_1(care_plans.cost)|interval=P90D)", "STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost))" as "STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost))", "STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)" as "STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)", "STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)" as "STDDEV(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)", "STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost))" as "STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost))", "STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~96926c25" as "STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~96926c25", "STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~f96e61ed" as "STDDEV(care_plans.ROLLING_MEAN_7(care_plans.cost)|inte~f96e61ed", "STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost))" as "STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost))", "STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~06ee3896" as "STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~06ee3896", "STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~55d39dc4" as "STDDEV(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|in~55d39dc4", "STDDEV(care_plans.cost)" as "STDDEV(care_plans.cost)", "STDDEV(care_plans.cost|interval=P30D)" as "STDDEV(care_plans.cost|interval=P30D)", "STDDEV(care_plans.cost|interval=P90D)" as "STDDEV(care_plans.cost|interval=P90D)", "SUM(care_plans.ABS(care_plans.cost))" as "SUM(care_plans.ABS(care_plans.cost))", "SUM(care_plans.ABS(care_plans.cost)|interval=P30D)" as "SUM(care_plans.ABS(care_plans.cost)|interval=P30D)", "SUM(care_plans.ABS(care_plans.cost)|interval=P90D)" as "SUM(care_plans.ABS(care_plans.cost)|interval=P90D)", "SUM(care_plans.LAG_1(care_plans.cost))" as "SUM(care_plans.LAG_1(care_plans.cost))", "SUM(care_plans.LAG_1(care_plans.cost)|interval=P30D)" as "SUM(care_plans.LAG_1(care_plans.cost)|interval=P30D)", "SUM(care_plans.LAG_1(care_plans.cost)|interval=P90D)" as "SUM(care_plans.LAG_1(care_plans.cost)|interval=P90D)", "SUM(care_plans.ROLLING_IQR_7(care_plans.cost))" as "SUM(care_plans.ROLLING_IQR_7(care_plans.cost))", "SUM(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)" as "SUM(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P30D)", "SUM(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)" as "SUM(care_plans.ROLLING_IQR_7(care_plans.cost)|interval=P90D)", "SUM(care_plans.ROLLING_MEAN_7(care_plans.cost))" as "SUM(care_plans.ROLLING_MEAN_7(care_plans.cost))", "SUM(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D)" as "SUM(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P30D)", "SUM(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D)" as "SUM(care_plans.ROLLING_MEAN_7(care_plans.cost)|interval=P90D)", "SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost))" as "SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost))", "SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D)" as "SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P30D)", "SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D)" as "SUM(care_plans.ROLLING_MEDIAN_7(care_plans.cost)|interval=P90D)", "SUM(care_plans.cost)" as "SUM(care_plans.cost)", "SUM(care_plans.cost|interval=P30D)" as "SUM(care_plans.cost|interval=P30D)", "SUM(care_plans.cost|interval=P90D)" as "SUM(care_plans.cost|interval=P90D)", age as age, severity_level as severity_level
        from patients_synth _ego
        )


        select * from patients_transform
        ) as t

        order by aod.as_of_date

Understanding the LATERAL Join

The generated SQL uses a pattern like:

LEFT JOIN LATERAL (
    SELECT care_plans_transform.cost, ...
    FROM care_plans_transform
    WHERE care_plans_transform.patient_id = patients.patient_id
      AND care_plans_transform.plan_date <= patients.admission_date
      AND patients.admission_date - care_plans_transform.plan_date <= interval 'P7D'
    ORDER BY care_plans_transform.plan_date DESC
    LIMIT 1
) AS care_plans_asof_for_patients ON true

This ensures:

Only matching patient_id
Care plan date is before or at admission date
Within the grace period
Most recent match (ORDER BY … DESC LIMIT 1)

5. Generated Features

target_features = featurizer.features[featurizer.target.alias]

print(f"Total features: {len(target_features)}")
print("\nFeatures from care_plans (via temporal join):")
care_plan_features = [f for f in target_features if "care_plans" in f.name.lower()]
for f in sorted(care_plan_features, key=lambda x: x.name)[:15]:
    print(f"  {f.name}")

Total features: 730

Features from care_plans (via temporal join):
  "ABS(patients.COUNT(care_plans.LAG_1(care_plans.treatment_type)))"
  "ABS(patients.COUNT(care_plans.LAG_1(care_plans.treatment_type)|inte~4f9badff)"
  "ABS(patients.COUNT(care_plans.LAG_1(care_plans.treatment_type)|inte~d7382445)"
  "ABS(patients.COUNT(care_plans.plan_date))"
  "ABS(patients.COUNT(care_plans.plan_date|interval=P30D))"
  "ABS(patients.COUNT(care_plans.plan_date|interval=P90D))"
  "ABS(patients.COUNT(care_plans.plan_id))"
  "ABS(patients.COUNT(care_plans.plan_id|interval=P30D))"
  "ABS(patients.COUNT(care_plans.plan_id|interval=P90D))"
  "ABS(patients.COUNT(care_plans.treatment_type))"
  "ABS(patients.COUNT(care_plans.treatment_type|interval=P30D))"
  "ABS(patients.COUNT(care_plans.treatment_type|interval=P90D))"
  "ABS(patients.MAX(care_plans.ABS(care_plans.cost)))"
  "ABS(patients.MAX(care_plans.ABS(care_plans.cost)|interval=P30D))"
  "ABS(patients.MAX(care_plans.ABS(care_plans.cost)|interval=P90D))"

6. When to Use Temporal Joins

Use temporal (as-of) joins when:

Point-in-time correctness matters: You need features as they would have been at a specific moment
Preventing data leakage: In ML, you can’t use future data to predict past events
Time-varying relationships: The “current” related record changes over time

Examples:

Customer’s current address at time of order
Patient’s latest diagnosis at time of treatment
Product’s price at time of purchase
Employee’s department at time of performance review

print("Summary")
print("=" * 40)
print(f"Target: {featurizer.target.alias}")
print(f"Temporal relationship: patients <- care_plans (as-of)")
print(f"Grace period: P7D")
print(f"Total features: {len(target_features)}")

Summary
========================================
Target: patients
Temporal relationship: patients <- care_plans (as-of)
Grace period: P7D
Total features: 730