{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Featurizer Tutorial: Temporal (As-Of) Joins\n",
    "\n",
    "This notebook demonstrates temporal joins in Featurizer using a healthcare scenario:\n",
    "- **Patients** (target entity) with admission dates\n",
    "- **Care Plans** (related entity) with plan dates\n",
    "\n",
    "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."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 1. Setup"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2026-06-21T19:29:15.675203Z",
     "iopub.status.busy": "2026-06-21T19:29:15.675128Z",
     "iopub.status.idle": "2026-06-21T19:29:15.680615Z",
     "shell.execute_reply": "2026-06-21T19:29:15.680351Z"
    }
   },
   "outputs": [],
   "source": [
    "import sys\n",
    "from pathlib import Path\n",
    "\n",
    "# This tutorial is database-free: it loads the config and inspects the\n",
    "# synthesized features and the generated SQL — none of which touch a\n",
    "# database. To actually *execute* the features against PostgreSQL, run the\n",
    "# example script instead (`just example <NN>`, or create_data.py +\n",
    "# run_example.py with DATABASE_URL / PG* set). See the example README.\n",
    "sys.path.insert(0, str(Path.cwd().parent.parent))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 2. Understanding Temporal Relationships\n",
    "\n",
    "The configuration defines a temporal relationship with `mode: as_of`:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2026-06-21T19:29:15.681948Z",
     "iopub.status.busy": "2026-06-21T19:29:15.681885Z",
     "iopub.status.idle": "2026-06-21T19:29:15.683699Z",
     "shell.execute_reply": "2026-06-21T19:29:15.683404Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "# Healthcare feature generation: Patients with temporal Care Plans\n",
      "\n",
      "target: patients\n",
      "max_depth: 2\n",
      "\n",
      "intervals:\n",
      "  - P30D  # Last 30 days\n",
      "  - P90D  # Last 90 days\n",
      "\n",
      "# A focused primitive set (the full default set would exceed PostgreSQL's 1664\n",
      "# columns-per-row limit on this config). Includes the rolling ordered-set stats\n",
      "# — rolling_median / rolling_iqr render as correlated subqueries (PostgreSQL\n",
      "# forbids OVER on percentile_cont), exercised end to end here.\n",
      "aggregations:\n",
      "  - count\n",
      "  - sum\n",
      "  - mean\n",
      "  - min\n",
      "  - max\n",
      "  - stddev\n",
      "  - median\n",
      "transformations:\n",
      "  - identity\n",
      "  - abs\n",
      "  - lag_1\n",
      "  - rolling_mean_7\n",
      "  - rolling_median_7\n",
      "  - rolling_iqr_7\n",
      "\n",
      "entities:\n",
      "  - alias: patients\n",
      "    id: patient_id\n",
      "    table: patients\n",
      "    temporal_ix: admission_date\n",
      "    variables:\n",
      "      age:\n",
      "        type: numeric\n",
      "      severity_level:\n",
      "        type: categorical\n",
      "\n",
      "  - alias: care_plans\n",
      "    id: plan_id\n",
      "    table: care_plans\n",
      "    temporal_ix: plan_date\n",
      "    variables:\n",
      "      treatment_type:\n",
      "        type: categorical\n",
      "      cost:\n",
      "        type: numeric\n",
      "\n",
      "relationships:\n",
      "  - parent:\n",
      "      entity: patients\n",
      "      key: patient_id\n",
      "    child:\n",
      "      entity: care_plans\n",
      "      key: patient_id\n",
      "    temporal:\n",
      "      mode: as_of\n",
      "      grace: P7D  # Allow matching plans up to 7 days in the future\n",
      "      child_time: plan_date\n",
      "\n"
     ]
    }
   ],
   "source": [
    "with open(\"config.yaml\") as f:\n",
    "    print(f.read())"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Key Temporal Configuration:\n",
    "\n",
    "```yaml\n",
    "temporal:\n",
    "  mode: as_of        # Enable as-of join semantics\n",
    "  grace: P7D         # Allow matching up to 7 days in the future\n",
    "  child_time: plan_date  # Override child entity's temporal column\n",
    "```\n",
    "\n",
    "This means: for each patient admission, find the most recent care plan where `plan_date <= admission_date + 7 days`."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 3. Load Configuration"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2026-06-21T19:29:15.695797Z",
     "iopub.status.busy": "2026-06-21T19:29:15.695722Z",
     "iopub.status.idle": "2026-06-21T19:29:15.917872Z",
     "shell.execute_reply": "2026-06-21T19:29:15.917505Z"
    }
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "\u001b[32m2026-06-21 13:29:15.899\u001b[0m | \u001b[34m\u001b[1mDEBUG   \u001b[0m | \u001b[36mfeaturizer.planner\u001b[0m:\u001b[36mplan\u001b[0m:\u001b[36m230\u001b[0m - \u001b[34m\u001b[1mStarting feature build for target patients\u001b[0m\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "\u001b[32m2026-06-21 13:29:15.900\u001b[0m | \u001b[34m\u001b[1mDEBUG   \u001b[0m | \u001b[36mfeaturizer.planner\u001b[0m:\u001b[36m_build_features\u001b[0m:\u001b[36m256\u001b[0m - \u001b[34m\u001b[1mbuild_features(patients) depth=0\u001b[0m\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "\u001b[32m2026-06-21 13:29:15.900\u001b[0m | \u001b[34m\u001b[1mDEBUG   \u001b[0m | \u001b[36mfeaturizer.planner\u001b[0m:\u001b[36m_build_features\u001b[0m:\u001b[36m256\u001b[0m - \u001b[34m\u001b[1mbuild_features(care_plans) depth=1\u001b[0m\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "\u001b[32m2026-06-21 13:29:15.900\u001b[0m | \u001b[1mINFO    \u001b[0m | \u001b[36mfeaturizer.planner\u001b[0m:\u001b[36m_build_features\u001b[0m:\u001b[36m276\u001b[0m - \u001b[1mMaximum recursion depth reached at depth 2; materializing care_plans without traversing further.\u001b[0m\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "\u001b[32m2026-06-21 13:29:15.900\u001b[0m | \u001b[34m\u001b[1mDEBUG   \u001b[0m | \u001b[36mfeaturizer.planner\u001b[0m:\u001b[36m_build_aggregations\u001b[0m:\u001b[36m1014\u001b[0m - \u001b[34m\u001b[1mProcessing backward relationship Entity(patients).patient_id -> Entity(care_plans).patient_id\u001b[0m\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "\u001b[32m2026-06-21 13:29:15.901\u001b[0m | \u001b[33m\u001b[1mWARNING \u001b[0m | \u001b[36mfeaturizer.planner\u001b[0m:\u001b[36m_apply_direct_roles\u001b[0m:\u001b[36m1155\u001b[0m - \u001b[33m\u001b[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.\u001b[0m\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Target: patients\n",
      "Intervals: ['P30D', 'P90D']\n"
     ]
    }
   ],
   "source": [
    "from featurizer import Featurizer\n",
    "\n",
    "featurizer = Featurizer(\"config.yaml\")\n",
    "\n",
    "print(f\"Target: {featurizer.target.alias}\")\n",
    "print(f\"Intervals: {featurizer.intervals}\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2026-06-21T19:29:15.918835Z",
     "iopub.status.busy": "2026-06-21T19:29:15.918758Z",
     "iopub.status.idle": "2026-06-21T19:29:15.920820Z",
     "shell.execute_reply": "2026-06-21T19:29:15.920463Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Relationship: patients -> care_plans\n",
      "  Temporal mode: as_of\n",
      "  Grace period: P7D\n",
      "  Child timestamp: None\n"
     ]
    }
   ],
   "source": [
    "# Examine the temporal relationship\n",
    "for rel in featurizer.relationships:\n",
    "    print(f\"Relationship: {rel.parent.alias} -> {rel.child.alias}\")\n",
    "    print(f\"  Temporal mode: {rel.temporal_mode}\")\n",
    "    print(f\"  Grace period: {rel.temporal_grace}\")\n",
    "    print(f\"  Child timestamp: {rel.temporal_child_field}\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 4. Examining the Generated SQL\n",
    "\n",
    "The key difference from regular joins is the `LEFT JOIN LATERAL` clause."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2026-06-21T19:29:15.921681Z",
     "iopub.status.busy": "2026-06-21T19:29:15.921622Z",
     "iopub.status.idle": "2026-06-21T19:29:15.926657Z",
     "shell.execute_reply": "2026-06-21T19:29:15.926333Z"
    }
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "\u001b[32m2026-06-21 13:29:15.922\u001b[0m | \u001b[34m\u001b[1mDEBUG   \u001b[0m | \u001b[36mfeaturizer.sql\u001b[0m:\u001b[36mrender\u001b[0m:\u001b[36m40\u001b[0m - \u001b[34m\u001b[1mRendered SQL for target 'patients': 5 CTEs, 248797 chars\u001b[0m\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Temporal join generates LEFT JOIN LATERAL:\n",
      "============================================================\n",
      "        cross join lateral (\n",
      "\n",
      "        with\n",
      "\n",
      "        \n",
      "        -- sythetize aggregations and direct features for care_plans\n",
      "        care_plans_synth as (\n",
      "        select\n",
      "        care_plans.plan_id, care_plans.plan_date, care_plans.patient_id, cost, treatment_type\n",
      "        from care_plans\n",
      "        \n",
      "        \n",
      "        )\n",
      "        ,\n",
      "        -- transform care_plans\n",
      "        care_plans_transform as (\n",
      "        select\n",
      "        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\n",
      "        from care_plans_synth _ego\n",
      "        )\n",
      "        ,\n",
      "        -- Aggregate for patients\n",
      "        care_plans_aggs_for_patients as (\n",
      "        select\n",
      "        care_plans_transform.patient_id,\n",
      "        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)\" \n",
      "        from care_plans_transform\n",
      "         where plan_date <= aod.as_of_date\n",
      "        group by patient_id\n",
      "        )\n",
      "        ,\n",
      "        -- sythetize aggregations and direct features for patients\n",
      "        patients_synth as (\n",
      "        select\n",
      "        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\n",
      "        from patients\n",
      "         left join \n",
      "         care_plans_aggs_for_patients on care_plans_aggs_for_patients.patient_id = patients.patient_id \n",
      "        )\n",
      "        ,\n",
      "        -- transform patients\n",
      "        patients_transform as (\n",
      "        select\n",
      "        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\n",
      "        from patients_synth _ego\n",
      "        )\n",
      "        \n",
      "\n",
      "        select * from patients_transform\n",
      "        ) as t\n",
      "\n",
      "        order by aod.as_of_date\n",
      "        \n"
     ]
    }
   ],
   "source": [
    "sql = featurizer.query\n",
    "\n",
    "# Find the LATERAL join\n",
    "if \"lateral\" in sql.lower():\n",
    "    print(\"Temporal join generates LEFT JOIN LATERAL:\")\n",
    "    print(\"=\" * 60)\n",
    "\n",
    "    # Extract the lateral join portion\n",
    "    lines = sql.split(\"\\n\")\n",
    "    in_lateral = False\n",
    "    for line in lines:\n",
    "        if \"lateral\" in line.lower():\n",
    "            in_lateral = True\n",
    "        if in_lateral:\n",
    "            print(line)\n",
    "            if \") as\" in line.lower() and \"on true\" in line.lower():\n",
    "                break"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Understanding the LATERAL Join\n",
    "\n",
    "The generated SQL uses a pattern like:\n",
    "\n",
    "```sql\n",
    "LEFT JOIN LATERAL (\n",
    "    SELECT care_plans_transform.cost, ...\n",
    "    FROM care_plans_transform\n",
    "    WHERE care_plans_transform.patient_id = patients.patient_id\n",
    "      AND care_plans_transform.plan_date <= patients.admission_date\n",
    "      AND patients.admission_date - care_plans_transform.plan_date <= interval 'P7D'\n",
    "    ORDER BY care_plans_transform.plan_date DESC\n",
    "    LIMIT 1\n",
    ") AS care_plans_asof_for_patients ON true\n",
    "```\n",
    "\n",
    "This ensures:\n",
    "1. Only matching patient_id\n",
    "2. Care plan date is before or at admission date\n",
    "3. Within the grace period\n",
    "4. Most recent match (ORDER BY ... DESC LIMIT 1)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 5. Generated Features"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2026-06-21T19:29:15.927773Z",
     "iopub.status.busy": "2026-06-21T19:29:15.927723Z",
     "iopub.status.idle": "2026-06-21T19:29:15.929567Z",
     "shell.execute_reply": "2026-06-21T19:29:15.929236Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Total features: 730\n",
      "\n",
      "Features from care_plans (via temporal join):\n",
      "  \"ABS(patients.COUNT(care_plans.LAG_1(care_plans.treatment_type)))\"\n",
      "  \"ABS(patients.COUNT(care_plans.LAG_1(care_plans.treatment_type)|inte~4f9badff)\"\n",
      "  \"ABS(patients.COUNT(care_plans.LAG_1(care_plans.treatment_type)|inte~d7382445)\"\n",
      "  \"ABS(patients.COUNT(care_plans.plan_date))\"\n",
      "  \"ABS(patients.COUNT(care_plans.plan_date|interval=P30D))\"\n",
      "  \"ABS(patients.COUNT(care_plans.plan_date|interval=P90D))\"\n",
      "  \"ABS(patients.COUNT(care_plans.plan_id))\"\n",
      "  \"ABS(patients.COUNT(care_plans.plan_id|interval=P30D))\"\n",
      "  \"ABS(patients.COUNT(care_plans.plan_id|interval=P90D))\"\n",
      "  \"ABS(patients.COUNT(care_plans.treatment_type))\"\n",
      "  \"ABS(patients.COUNT(care_plans.treatment_type|interval=P30D))\"\n",
      "  \"ABS(patients.COUNT(care_plans.treatment_type|interval=P90D))\"\n",
      "  \"ABS(patients.MAX(care_plans.ABS(care_plans.cost)))\"\n",
      "  \"ABS(patients.MAX(care_plans.ABS(care_plans.cost)|interval=P30D))\"\n",
      "  \"ABS(patients.MAX(care_plans.ABS(care_plans.cost)|interval=P90D))\"\n"
     ]
    }
   ],
   "source": [
    "target_features = featurizer.features[featurizer.target.alias]\n",
    "\n",
    "print(f\"Total features: {len(target_features)}\")\n",
    "print(\"\\nFeatures from care_plans (via temporal join):\")\n",
    "care_plan_features = [f for f in target_features if \"care_plans\" in f.name.lower()]\n",
    "for f in sorted(care_plan_features, key=lambda x: x.name)[:15]:\n",
    "    print(f\"  {f.name}\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 6. When to Use Temporal Joins\n",
    "\n",
    "Use temporal (as-of) joins when:\n",
    "\n",
    "1. **Point-in-time correctness matters**: You need features as they would have been at a specific moment\n",
    "2. **Preventing data leakage**: In ML, you can't use future data to predict past events\n",
    "3. **Time-varying relationships**: The \"current\" related record changes over time\n",
    "\n",
    "### Examples:\n",
    "- Customer's current address at time of order\n",
    "- Patient's latest diagnosis at time of treatment\n",
    "- Product's price at time of purchase\n",
    "- Employee's department at time of performance review"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "execution": {
     "iopub.execute_input": "2026-06-21T19:29:15.930418Z",
     "iopub.status.busy": "2026-06-21T19:29:15.930369Z",
     "iopub.status.idle": "2026-06-21T19:29:15.931861Z",
     "shell.execute_reply": "2026-06-21T19:29:15.931532Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Summary\n",
      "========================================\n",
      "Target: patients\n",
      "Temporal relationship: patients <- care_plans (as-of)\n",
      "Grace period: P7D\n",
      "Total features: 730\n"
     ]
    }
   ],
   "source": [
    "print(\"Summary\")\n",
    "print(\"=\" * 40)\n",
    "print(f\"Target: {featurizer.target.alias}\")\n",
    "print(f\"Temporal relationship: patients <- care_plans (as-of)\")\n",
    "print(f\"Grace period: P7D\")\n",
    "print(f\"Total features: {len(target_features)}\")"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.12.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}