ghickman

#!/usr/local/bin/bash

# use bash 4 from homebrew

set -e
shopt -s globstar

FORMAT="%Y-%m-%d_%H-%M-%S"

# Video files

ghickman

WITH ethnicities AS (
          SELECT
            Patient_ID,
            date,
            ethnicity_code,
            ROW_NUMBER() OVER (
                PARTITION BY Patient_ID ORDER BY date DESC
            ) AS row_num
          FROM (
            SELECT