Formulas that run as dbt macros

REPLACE(TRIM({{ phone }}), '-', '')

REPLACE(TRIM({{ phone }}), '-', '')

REPLACE(TRIM({{ phone }}), '-', '')

REPLACE(TRIM({{ phone }}), '-', '')

REPLACE(TRIM({{ phone }}), '-', '')

REPLACE(TRIM({{ phone }}), '-', '')

REPLACE(TRIM({{ phone }}), '-', '')

REPLACE(TRIM({{ phone }}), '-', '')

TRIM({{ text }})

TRIM({{ text }})

TRIM({{ text }})

TRIM({{ text }})

TRIM({{ text }})

TRIM({{ text }})

TRIM({{ text }})

TRIM({{ text }})

LOWER(TRIM({{ email }}))

LOWER(TRIM({{ email }}))

LOWER(TRIM({{ email }}))

LOWER(TRIM({{ email }}))

LOWER(TRIM({{ email }}))

LOWER(TRIM({{ email }}))

LOWER(TRIM({{ email }}))

LOWER(TRIM({{ email }}))

UPPER(TRIM({{ code }}))

UPPER(TRIM({{ code }}))

UPPER(TRIM({{ code }}))

UPPER(TRIM({{ code }}))

UPPER(TRIM({{ code }}))

UPPER(TRIM({{ code }}))

UPPER(TRIM({{ code }}))

UPPER(TRIM({{ code }}))

UPPER(LEFT(TRIM({{ state }}), 2))

UPPER(LEFT(TRIM({{ state }}), 2))

UPPER(LEFT(TRIM({{ state }}), 2))

UPPER(LEFT(TRIM({{ state }}), 2))

UPPER(LEFT(TRIM({{ state }}), 2))

UPPER(LEFT(TRIM({{ state }}), 2))

UPPER(SUBSTR(TRIM({{ state }}), 1, 2))

UPPER(LEFT(TRIM({{ state }}), 2))

LEFT(TRIM({{ zip }}), 5)

LEFT(TRIM({{ zip }}), 5)

LEFT(TRIM({{ zip }}), 5)

LEFT(TRIM({{ zip }}), 5)

LEFT(TRIM({{ zip }}), 5)

LEFT(TRIM({{ zip }}), 5)

SUBSTR(TRIM({{ zip }}), 1, 5)

LEFT(TRIM({{ zip }}), 5)

{{ cents }} / 100

CAST({{ cents }} AS BIGNUMERIC) / 100

CAST({{ cents }} AS DECIMAL(38, 10)) / 100

CAST({{ cents }} AS DECIMAL(38, 10)) / 100

CAST({{ cents }} AS NUMERIC) / 100

CAST({{ cents }} AS DECIMAL(38, 10)) / 100

{{ cents }} / 100

{{ cents }} / 100

ROUND({{ amount }} * 100, 0)

ROUND({{ amount }} * 100, 0)

ROUND({{ amount }} * 100, 0)

ROUND({{ amount }} * 100, 0)

ROUND(CAST({{ amount }} * 100 AS NUMERIC), 0)

ROUND({{ amount }} * 100, 0)

ROUND({{ amount }} * 100, 0)

ROUND({{ amount }} * 100, 0)

ROUND({{ amount }}, 2)

ROUND({{ amount }}, 2)

ROUND({{ amount }}, 2)

ROUND({{ amount }}, 2)

ROUND(CAST({{ amount }} AS NUMERIC), 2)

ROUND({{ amount }}, 2)

ROUND({{ amount }}, 2)

ROUND({{ amount }}, 2)

{{ qty }} * {{ price }}

{{ qty }} * {{ price }}

{{ qty }} * {{ price }}

{{ qty }} * {{ price }}

{{ qty }} * {{ price }}

{{ qty }} * {{ price }}

{{ qty }} * {{ price }}

{{ qty }} * {{ price }}

ROUND({{ amount }} * {{ rate }}, 2)

ROUND({{ amount }} * {{ rate }}, 2)

ROUND({{ amount }} * {{ rate }}, 2)

ROUND({{ amount }} * {{ rate }}, 2)

ROUND(CAST({{ amount }} * {{ rate }} AS NUMERIC), 2)

ROUND({{ amount }} * {{ rate }}, 2)

ROUND({{ amount }} * {{ rate }}, 2)

ROUND({{ amount }} * {{ rate }}, 2)

EXTRACT(YEAR FROM {{ day }})

EXTRACT(YEAR FROM {{ day }})

EXTRACT(YEAR FROM {{ day }})

EXTRACT(YEAR FROM {{ day }})

EXTRACT(YEAR FROM {{ day }})

DATEPART(year, {{ day }})

EXTRACT(YEAR FROM {{ day }})

EXTRACT(YEAR FROM {{ day }})

EXTRACT(MONTH FROM {{ day }})

EXTRACT(MONTH FROM {{ day }})

EXTRACT(MONTH FROM {{ day }})

EXTRACT(MONTH FROM {{ day }})

EXTRACT(MONTH FROM {{ day }})

DATEPART(month, {{ day }})

EXTRACT(MONTH FROM {{ day }})

EXTRACT(MONTH FROM {{ day }})

({{ text }} IS NULL)

({{ text }} IS NULL)

({{ text }} IS NULL)

({{ text }} IS NULL)

({{ text }} IS NULL)

({{ text }} IS NULL)

({{ text }} IS NULL)

({{ text }} IS NULL)

COALESCE({{ value }}, {{ fallback }})

COALESCE({{ value }}, {{ fallback }})

COALESCE({{ value }}, {{ fallback }})

COALESCE({{ value }}, {{ fallback }})

COALESCE({{ value }}, {{ fallback }})

COALESCE({{ value }}, {{ fallback }})

COALESCE({{ value }}, {{ fallback }})

COALESCE({{ value }}, {{ fallback }})

ABS({{ amount }})

ABS({{ amount }})

ABS({{ amount }})

ABS({{ amount }})

ABS({{ amount }})

ABS({{ amount }})

ABS({{ amount }})

ABS({{ amount }})

CASE WHEN {{ whole }} = 0 THEN 0 ELSE ROUND({{ part }} / {{ whole }} * 100, 1) END

CASE WHEN {{ whole }} = 0 THEN 0 ELSE ROUND(CAST({{ part }} AS BIGNUMERIC) / {{ whole }} * 100, 1) END

CASE WHEN {{ whole }} = 0 THEN 0 ELSE ROUND(CAST({{ part }} AS DECIMAL(38, 10)) / {{ whole }} * 100, 1) END

CASE WHEN {{ whole }} = 0 THEN 0 ELSE ROUND(CAST({{ part }} AS DECIMAL(38, 10)) / {{ whole }} * 100, 1) END

CASE WHEN {{ whole }} = 0 THEN 0 ELSE ROUND(CAST(CAST({{ part }} AS NUMERIC) / {{ whole }} * 100 AS NUMERIC), 1) END

CASE WHEN {{ whole }} = 0 THEN 0 ELSE ROUND(CAST({{ part }} AS DECIMAL(38, 10)) / {{ whole }} * 100, 1) END

CASE WHEN {{ whole }} = 0 THEN 0 ELSE ROUND({{ part }} / {{ whole }} * 100, 1) END

CASE WHEN {{ whole }} = 0 THEN 0 ELSE ROUND({{ part }} / {{ whole }} * 100, 1) END

{{ price }} - {{ cost }}

{{ price }} - {{ cost }}

{{ price }} - {{ cost }}

{{ price }} - {{ cost }}

{{ price }} - {{ cost }}

{{ price }} - {{ cost }}

{{ price }} - {{ cost }}

{{ price }} - {{ cost }}

LEFT(UPPER({{ sku }}), 3)

LEFT(UPPER({{ sku }}), 3)

LEFT(UPPER({{ sku }}), 3)

LEFT(UPPER({{ sku }}), 3)

LEFT(UPPER({{ sku }}), 3)

LEFT(UPPER({{ sku }}), 3)

SUBSTR(UPPER({{ sku }}), 1, 3)

LEFT(UPPER({{ sku }}), 3)

RIGHT(TRIM({{ account }}), 4)

RIGHT(TRIM({{ account }}), 4)

RIGHT(TRIM({{ account }}), 4)

RIGHT(TRIM({{ account }}), 4)

RIGHT(TRIM({{ account }}), 4)

RIGHT(TRIM({{ account }}), 4)

SUBSTR(TRIM({{ account }}), -4)

RIGHT(TRIM({{ account }}), 4)

LENGTH(TRIM({{ text }}))

LENGTH(TRIM({{ text }}))

LENGTH(TRIM({{ text }}))

LENGTH(TRIM({{ text }}))

LENGTH(TRIM({{ text }}))

LEN(TRIM({{ text }}))

LENGTH(TRIM({{ text }}))

CHAR_LENGTH(TRIM({{ text }}))

{{ amount }} < 0

{{ amount }} < 0

{{ amount }} < 0

{{ amount }} < 0

{{ amount }} < 0

{{ amount }} < 0

{{ amount }} < 0

{{ amount }} < 0

DATEADD(day, {{ terms_days }}, {{ invoice_day }})

DATE_ADD({{ invoice_day }}, INTERVAL {{ terms_days }} DAY)

DATEADD(day, {{ terms_days }}, {{ invoice_day }})

({{ invoice_day }} + ({{ terms_days }}) * INTERVAL '1 day')

({{ invoice_day }} + ({{ terms_days }}) * INTERVAL '1 day')

DATEADD(day, {{ terms_days }}, {{ invoice_day }})

({{ invoice_day }} + NUMTODSINTERVAL({{ terms_days }}, 'DAY'))

DATE_ADD({{ invoice_day }}, INTERVAL {{ terms_days }} DAY)

DATEADD(month, 1, {{ day }})

DATE_ADD({{ day }}, INTERVAL 1 MONTH)

DATEADD(month, 1, {{ day }})

({{ day }} + (1) * INTERVAL '1 month')

({{ day }} + (1) * INTERVAL '1 month')

DATEADD(month, 1, {{ day }})

ADD_MONTHS({{ day }}, 1)

DATE_ADD({{ day }}, INTERVAL 1 MONTH)

FLOOR({{ qty }})

FLOOR({{ qty }})

FLOOR({{ qty }})

FLOOR({{ qty }})

FLOOR({{ qty }})

FLOOR({{ qty }})

FLOOR({{ qty }})

FLOOR({{ qty }})

CAST(TRIM({{ text }}) AS NUMBER(38, 10))

CAST(TRIM({{ text }}) AS NUMERIC)

CAST(TRIM({{ text }}) AS DECIMAL(38, 10))

CAST(TRIM({{ text }}) AS DECIMAL(38, 10))

CAST(TRIM({{ text }}) AS NUMERIC)

CAST(TRIM({{ text }}) AS DECIMAL(38, 10))

CAST(TRIM({{ text }}) AS NUMBER)

CAST(TRIM({{ text }}) AS DECIMAL(38, 10))

CAST({{ text }} AS DATE)

CAST({{ text }} AS DATE)

CAST({{ text }} AS DATE)

CAST({{ text }} AS DATE)

CAST({{ text }} AS DATE)

CAST({{ text }} AS DATE)

CAST({{ text }} AS DATE)

CAST({{ text }} AS DATE)

MOD({{ order_number }}, 2) = 0

MOD({{ order_number }}, 2) = 0

MOD({{ order_number }}, 2) = 0

MOD({{ order_number }}, 2) = 0

MOD({{ order_number }}, 2) = 0

(({{ order_number }}) % (2)) = 0

MOD({{ order_number }}, 2) = 0

MOD({{ order_number }}, 2) = 0

{{ length_in }} * {{ width_in }} * {{ height_in }}

{{ length_in }} * {{ width_in }} * {{ height_in }}

{{ length_in }} * {{ width_in }} * {{ height_in }}

{{ length_in }} * {{ width_in }} * {{ height_in }}

{{ length_in }} * {{ width_in }} * {{ height_in }}

{{ length_in }} * {{ width_in }} * {{ height_in }}

{{ length_in }} * {{ width_in }} * {{ height_in }}

{{ length_in }} * {{ width_in }} * {{ height_in }}

LOWER(TRIM({{ channel }})) = 'web'

LOWER(TRIM({{ channel }})) = 'web'

LOWER(TRIM({{ channel }})) = 'web'

LOWER(TRIM({{ channel }})) = 'web'

LOWER(TRIM({{ channel }})) = 'web'

LOWER(TRIM({{ channel }})) = 'web'

LOWER(TRIM({{ channel }})) = 'web'

LOWER(TRIM({{ channel }})) = 'web'

{{ mrr }} * 12

{{ mrr }} * 12

{{ mrr }} * 12

{{ mrr }} * 12

{{ mrr }} * 12

{{ mrr }} * 12

{{ mrr }} * 12

{{ mrr }} * 12

CONCAT(COALESCE(CAST(TRIM({{ first }}) AS VARCHAR), ''), ' ', COALESCE(CAST(TRIM({{ last }}) AS VARCHAR), ''))

CONCAT(COALESCE(CAST(TRIM({{ first }}) AS STRING), ''), ' ', COALESCE(CAST(TRIM({{ last }}) AS STRING), ''))

CONCAT(COALESCE(CAST(TRIM({{ first }}) AS STRING), ''), ' ', COALESCE(CAST(TRIM({{ last }}) AS STRING), ''))

(COALESCE(CAST(TRIM({{ first }}) AS VARCHAR), '') || ' ' || COALESCE(CAST(TRIM({{ last }}) AS VARCHAR), ''))

CONCAT(TRIM({{ first }}), ' ', TRIM({{ last }}))

CONCAT(TRIM({{ first }}), ' ', TRIM({{ last }}))

(TRIM({{ first }}) || ' ' || TRIM({{ last }}))

CONCAT(COALESCE(CAST(TRIM({{ first }}) AS CHAR), ''), ' ', COALESCE(CAST(TRIM({{ last }}) AS CHAR), ''))

CONCAT(COALESCE(CAST(UPPER(LEFT(TRIM({{ name }}), 1)) AS VARCHAR), ''), COALESCE(CAST(LOWER(SUBSTRING(TRIM({{ name }}), 2, LENGTH(TRIM({{ name }})))) AS VARCHAR), ''))

CONCAT(COALESCE(CAST(UPPER(LEFT(TRIM({{ name }}), 1)) AS STRING), ''), COALESCE(CAST(LOWER(SUBSTR(TRIM({{ name }}), 2, LENGTH(TRIM({{ name }})))) AS STRING), ''))

CONCAT(COALESCE(CAST(UPPER(LEFT(TRIM({{ name }}), 1)) AS STRING), ''), COALESCE(CAST(LOWER(SUBSTRING(TRIM({{ name }}), 2, LENGTH(TRIM({{ name }})))) AS STRING), ''))

(COALESCE(CAST(UPPER(LEFT(TRIM({{ name }}), 1)) AS VARCHAR), '') || COALESCE(CAST(LOWER(SUBSTRING(TRIM({{ name }}), 2, LENGTH(TRIM({{ name }})))) AS VARCHAR), ''))

CONCAT(UPPER(LEFT(TRIM({{ name }}), 1)), LOWER(SUBSTRING(TRIM({{ name }}), 2, LENGTH(TRIM({{ name }})))))

CONCAT(UPPER(LEFT(TRIM({{ name }}), 1)), LOWER(SUBSTRING(TRIM({{ name }}), 2, LEN(TRIM({{ name }})))))

(UPPER(SUBSTR(TRIM({{ name }}), 1, 1)) || LOWER(SUBSTR(TRIM({{ name }}), 2, LENGTH(TRIM({{ name }})))))

CONCAT(COALESCE(CAST(UPPER(LEFT(TRIM({{ name }}), 1)) AS CHAR), ''), COALESCE(CAST(LOWER(SUBSTRING(TRIM({{ name }}), 2, CHAR_LENGTH(TRIM({{ name }})))) AS CHAR), ''))

NOT ((LOWER(TRIM({{ email }})) LIKE '%@gmail.com' ESCAPE '!' OR LOWER(TRIM({{ email }})) LIKE '%@yahoo.com' ESCAPE '!' OR LOWER(TRIM({{ email }})) LIKE '%@outlook.com' ESCAPE '!'))

NOT ((LOWER(TRIM({{ email }})) LIKE '%@gmail.com' OR LOWER(TRIM({{ email }})) LIKE '%@yahoo.com' OR LOWER(TRIM({{ email }})) LIKE '%@outlook.com'))

NOT ((LOWER(TRIM({{ email }})) LIKE '%@gmail.com' ESCAPE '!' OR LOWER(TRIM({{ email }})) LIKE '%@yahoo.com' ESCAPE '!' OR LOWER(TRIM({{ email }})) LIKE '%@outlook.com' ESCAPE '!'))

NOT ((LOWER(TRIM({{ email }})) LIKE '%@gmail.com' ESCAPE '!' OR LOWER(TRIM({{ email }})) LIKE '%@yahoo.com' ESCAPE '!' OR LOWER(TRIM({{ email }})) LIKE '%@outlook.com' ESCAPE '!'))

NOT ((LOWER(TRIM({{ email }})) LIKE '%@gmail.com' ESCAPE '!' OR LOWER(TRIM({{ email }})) LIKE '%@yahoo.com' ESCAPE '!' OR LOWER(TRIM({{ email }})) LIKE '%@outlook.com' ESCAPE '!'))

NOT ((LOWER(TRIM({{ email }})) LIKE '%@gmail.com' ESCAPE '!' OR LOWER(TRIM({{ email }})) LIKE '%@yahoo.com' ESCAPE '!' OR LOWER(TRIM({{ email }})) LIKE '%@outlook.com' ESCAPE '!'))

NOT ((LOWER(TRIM({{ email }})) LIKE '%@gmail.com' ESCAPE '!' OR LOWER(TRIM({{ email }})) LIKE '%@yahoo.com' ESCAPE '!' OR LOWER(TRIM({{ email }})) LIKE '%@outlook.com' ESCAPE '!'))

NOT ((LOWER(TRIM({{ email }})) LIKE '%@gmail.com' ESCAPE '!' OR LOWER(TRIM({{ email }})) LIKE '%@yahoo.com' ESCAPE '!' OR LOWER(TRIM({{ email }})) LIKE '%@outlook.com' ESCAPE '!'))

CASE WHEN {{ total }} >= 500 THEN 'Large' WHEN {{ total }} >= 100 THEN 'Medium' ELSE 'Small' END

CASE WHEN {{ total }} >= 500 THEN 'Large' WHEN {{ total }} >= 100 THEN 'Medium' ELSE 'Small' END

CASE WHEN {{ total }} >= 500 THEN 'Large' WHEN {{ total }} >= 100 THEN 'Medium' ELSE 'Small' END

CASE WHEN {{ total }} >= 500 THEN 'Large' WHEN {{ total }} >= 100 THEN 'Medium' ELSE 'Small' END

CASE WHEN {{ total }} >= 500 THEN 'Large' WHEN {{ total }} >= 100 THEN 'Medium' ELSE 'Small' END

CASE WHEN {{ total }} >= 500 THEN 'Large' WHEN {{ total }} >= 100 THEN 'Medium' ELSE 'Small' END

CASE WHEN {{ total }} >= 500 THEN 'Large' WHEN {{ total }} >= 100 THEN 'Medium' ELSE 'Small' END

CASE WHEN {{ total }} >= 500 THEN 'Large' WHEN {{ total }} >= 100 THEN 'Medium' ELSE 'Small' END

CASE WHEN EXTRACT(MONTH FROM {{ day }}) <= 3 THEN 'Q1' WHEN EXTRACT(MONTH FROM {{ day }}) <= 6 THEN 'Q2' WHEN EXTRACT(MONTH FROM {{ day }}) <= 9 THEN 'Q3' ELSE 'Q4' END

CASE WHEN EXTRACT(MONTH FROM {{ day }}) <= 3 THEN 'Q1' WHEN EXTRACT(MONTH FROM {{ day }}) <= 6 THEN 'Q2' WHEN EXTRACT(MONTH FROM {{ day }}) <= 9 THEN 'Q3' ELSE 'Q4' END

CASE WHEN EXTRACT(MONTH FROM {{ day }}) <= 3 THEN 'Q1' WHEN EXTRACT(MONTH FROM {{ day }}) <= 6 THEN 'Q2' WHEN EXTRACT(MONTH FROM {{ day }}) <= 9 THEN 'Q3' ELSE 'Q4' END

CASE WHEN EXTRACT(MONTH FROM {{ day }}) <= 3 THEN 'Q1' WHEN EXTRACT(MONTH FROM {{ day }}) <= 6 THEN 'Q2' WHEN EXTRACT(MONTH FROM {{ day }}) <= 9 THEN 'Q3' ELSE 'Q4' END

CASE WHEN EXTRACT(MONTH FROM {{ day }}) <= 3 THEN 'Q1' WHEN EXTRACT(MONTH FROM {{ day }}) <= 6 THEN 'Q2' WHEN EXTRACT(MONTH FROM {{ day }}) <= 9 THEN 'Q3' ELSE 'Q4' END

CASE WHEN DATEPART(month, {{ day }}) <= 3 THEN 'Q1' WHEN DATEPART(month, {{ day }}) <= 6 THEN 'Q2' WHEN DATEPART(month, {{ day }}) <= 9 THEN 'Q3' ELSE 'Q4' END

CASE WHEN EXTRACT(MONTH FROM {{ day }}) <= 3 THEN 'Q1' WHEN EXTRACT(MONTH FROM {{ day }}) <= 6 THEN 'Q2' WHEN EXTRACT(MONTH FROM {{ day }}) <= 9 THEN 'Q3' ELSE 'Q4' END

CASE WHEN EXTRACT(MONTH FROM {{ day }}) <= 3 THEN 'Q1' WHEN EXTRACT(MONTH FROM {{ day }}) <= 6 THEN 'Q2' WHEN EXTRACT(MONTH FROM {{ day }}) <= 9 THEN 'Q3' ELSE 'Q4' END

CASE WHEN EXTRACT(MONTH FROM {{ day }}) >= 7 THEN EXTRACT(YEAR FROM {{ day }}) + 1 ELSE EXTRACT(YEAR FROM {{ day }}) END

CASE WHEN EXTRACT(MONTH FROM {{ day }}) >= 7 THEN EXTRACT(YEAR FROM {{ day }}) + 1 ELSE EXTRACT(YEAR FROM {{ day }}) END

CASE WHEN EXTRACT(MONTH FROM {{ day }}) >= 7 THEN EXTRACT(YEAR FROM {{ day }}) + 1 ELSE EXTRACT(YEAR FROM {{ day }}) END

CASE WHEN EXTRACT(MONTH FROM {{ day }}) >= 7 THEN EXTRACT(YEAR FROM {{ day }}) + 1 ELSE EXTRACT(YEAR FROM {{ day }}) END

CASE WHEN EXTRACT(MONTH FROM {{ day }}) >= 7 THEN EXTRACT(YEAR FROM {{ day }}) + 1 ELSE EXTRACT(YEAR FROM {{ day }}) END

CASE WHEN DATEPART(month, {{ day }}) >= 7 THEN DATEPART(year, {{ day }}) + 1 ELSE DATEPART(year, {{ day }}) END

CASE WHEN EXTRACT(MONTH FROM {{ day }}) >= 7 THEN EXTRACT(YEAR FROM {{ day }}) + 1 ELSE EXTRACT(YEAR FROM {{ day }}) END

CASE WHEN EXTRACT(MONTH FROM {{ day }}) >= 7 THEN EXTRACT(YEAR FROM {{ day }}) + 1 ELSE EXTRACT(YEAR FROM {{ day }}) END

ROUND({{ price }} * (1 - {{ pct }} / 100), 2)

ROUND({{ price }} * (1 - CAST({{ pct }} AS BIGNUMERIC) / 100), 2)

ROUND({{ price }} * (1 - CAST({{ pct }} AS DECIMAL(38, 10)) / 100), 2)

ROUND({{ price }} * (1 - CAST({{ pct }} AS DECIMAL(38, 10)) / 100), 2)

ROUND(CAST({{ price }} * (1 - CAST({{ pct }} AS NUMERIC) / 100) AS NUMERIC), 2)

ROUND({{ price }} * (1 - CAST({{ pct }} AS DECIMAL(38, 10)) / 100), 2)

ROUND({{ price }} * (1 - {{ pct }} / 100), 2)

ROUND({{ price }} * (1 - {{ pct }} / 100), 2)

CASE WHEN {{ price }} = 0 THEN 0 ELSE ROUND(({{ price }} - {{ cost }}) / {{ price }} * 100, 1) END

CASE WHEN {{ price }} = 0 THEN 0 ELSE ROUND(CAST(({{ price }} - {{ cost }}) AS BIGNUMERIC) / {{ price }} * 100, 1) END

CASE WHEN {{ price }} = 0 THEN 0 ELSE ROUND(CAST(({{ price }} - {{ cost }}) AS DECIMAL(38, 10)) / {{ price }} * 100, 1) END

CASE WHEN {{ price }} = 0 THEN 0 ELSE ROUND(CAST(({{ price }} - {{ cost }}) AS DECIMAL(38, 10)) / {{ price }} * 100, 1) END

CASE WHEN {{ price }} = 0 THEN 0 ELSE ROUND(CAST(CAST(({{ price }} - {{ cost }}) AS NUMERIC) / {{ price }} * 100 AS NUMERIC), 1) END

CASE WHEN {{ price }} = 0 THEN 0 ELSE ROUND(CAST(({{ price }} - {{ cost }}) AS DECIMAL(38, 10)) / {{ price }} * 100, 1) END

CASE WHEN {{ price }} = 0 THEN 0 ELSE ROUND(({{ price }} - {{ cost }}) / {{ price }} * 100, 1) END

CASE WHEN {{ price }} = 0 THEN 0 ELSE ROUND(({{ price }} - {{ cost }}) / {{ price }} * 100, 1) END

CASE WHEN {{ weight_lb }} <= 1 THEN 5.95 WHEN {{ weight_lb }} <= 5 THEN 9.95 ELSE 14.95 END

CASE WHEN {{ weight_lb }} <= 1 THEN BIGNUMERIC '5.95' WHEN {{ weight_lb }} <= 5 THEN BIGNUMERIC '9.95' ELSE BIGNUMERIC '14.95' END

CASE WHEN {{ weight_lb }} <= 1 THEN 5.95 WHEN {{ weight_lb }} <= 5 THEN 9.95 ELSE 14.95 END

CASE WHEN {{ weight_lb }} <= 1 THEN 5.95 WHEN {{ weight_lb }} <= 5 THEN 9.95 ELSE 14.95 END

CASE WHEN {{ weight_lb }} <= 1 THEN 5.95 WHEN {{ weight_lb }} <= 5 THEN 9.95 ELSE 14.95 END

CASE WHEN {{ weight_lb }} <= 1 THEN 5.95 WHEN {{ weight_lb }} <= 5 THEN 9.95 ELSE 14.95 END

CASE WHEN {{ weight_lb }} <= 1 THEN 5.95 WHEN {{ weight_lb }} <= 5 THEN 9.95 ELSE 14.95 END

CASE WHEN {{ weight_lb }} <= 1 THEN 5.95 WHEN {{ weight_lb }} <= 5 THEN 9.95 ELSE 14.95 END

LOWER(LOWER(TRIM({{ status }}))) IN (LOWER('paid'), LOWER('settled'), LOWER('captured'))

LOWER(LOWER(TRIM({{ status }}))) IN (LOWER('paid'), LOWER('settled'), LOWER('captured'))

LOWER(LOWER(TRIM({{ status }}))) IN (LOWER('paid'), LOWER('settled'), LOWER('captured'))

LOWER(LOWER(TRIM({{ status }}))) IN (LOWER('paid'), LOWER('settled'), LOWER('captured'))

LOWER(LOWER(TRIM({{ status }}))) IN (LOWER('paid'), LOWER('settled'), LOWER('captured'))

LOWER(LOWER(TRIM({{ status }}))) IN (LOWER('paid'), LOWER('settled'), LOWER('captured'))

LOWER(LOWER(TRIM({{ status }}))) IN (LOWER('paid'), LOWER('settled'), LOWER('captured'))

LOWER(LOWER(TRIM({{ status }}))) IN (LOWER('paid'), LOWER('settled'), LOWER('captured'))

CASE WHEN LOWER(UPPER(TRIM({{ state }}))) IN (LOWER('CA'), LOWER('OR'), LOWER('WA'), LOWER('NV'), LOWER('AZ')) THEN 'West' WHEN LOWER(UPPER(TRIM({{ state }}))) IN (LOWER('NY'), LOWER('NJ'), LOWER('MA'), LOWER('PA'), LOWER('CT')) THEN 'Northeast' WHEN LOWER(UPPER(TRIM({{ state }}))) IN (LOWER('TX'), LOWER('OK'), LOWER('LA'), LOWER('AR')) THEN 'South Central' ELSE 'Central' END

CASE WHEN LOWER(UPPER(TRIM({{ state }}))) IN (LOWER('CA'), LOWER('OR'), LOWER('WA'), LOWER('NV'), LOWER('AZ')) THEN 'West' WHEN LOWER(UPPER(TRIM({{ state }}))) IN (LOWER('NY'), LOWER('NJ'), LOWER('MA'), LOWER('PA'), LOWER('CT')) THEN 'Northeast' WHEN LOWER(UPPER(TRIM({{ state }}))) IN (LOWER('TX'), LOWER('OK'), LOWER('LA'), LOWER('AR')) THEN 'South Central' ELSE 'Central' END

CASE WHEN LOWER(UPPER(TRIM({{ state }}))) IN (LOWER('CA'), LOWER('OR'), LOWER('WA'), LOWER('NV'), LOWER('AZ')) THEN 'West' WHEN LOWER(UPPER(TRIM({{ state }}))) IN (LOWER('NY'), LOWER('NJ'), LOWER('MA'), LOWER('PA'), LOWER('CT')) THEN 'Northeast' WHEN LOWER(UPPER(TRIM({{ state }}))) IN (LOWER('TX'), LOWER('OK'), LOWER('LA'), LOWER('AR')) THEN 'South Central' ELSE 'Central' END

CASE WHEN LOWER(UPPER(TRIM({{ state }}))) IN (LOWER('CA'), LOWER('OR'), LOWER('WA'), LOWER('NV'), LOWER('AZ')) THEN 'West' WHEN LOWER(UPPER(TRIM({{ state }}))) IN (LOWER('NY'), LOWER('NJ'), LOWER('MA'), LOWER('PA'), LOWER('CT')) THEN 'Northeast' WHEN LOWER(UPPER(TRIM({{ state }}))) IN (LOWER('TX'), LOWER('OK'), LOWER('LA'), LOWER('AR')) THEN 'South Central' ELSE 'Central' END

CASE WHEN LOWER(UPPER(TRIM({{ state }}))) IN (LOWER('CA'), LOWER('OR'), LOWER('WA'), LOWER('NV'), LOWER('AZ')) THEN 'West' WHEN LOWER(UPPER(TRIM({{ state }}))) IN (LOWER('NY'), LOWER('NJ'), LOWER('MA'), LOWER('PA'), LOWER('CT')) THEN 'Northeast' WHEN LOWER(UPPER(TRIM({{ state }}))) IN (LOWER('TX'), LOWER('OK'), LOWER('LA'), LOWER('AR')) THEN 'South Central' ELSE 'Central' END

CASE WHEN LOWER(UPPER(TRIM({{ state }}))) IN (LOWER('CA'), LOWER('OR'), LOWER('WA'), LOWER('NV'), LOWER('AZ')) THEN 'West' WHEN LOWER(UPPER(TRIM({{ state }}))) IN (LOWER('NY'), LOWER('NJ'), LOWER('MA'), LOWER('PA'), LOWER('CT')) THEN 'Northeast' WHEN LOWER(UPPER(TRIM({{ state }}))) IN (LOWER('TX'), LOWER('OK'), LOWER('LA'), LOWER('AR')) THEN 'South Central' ELSE 'Central' END

CASE WHEN LOWER(UPPER(TRIM({{ state }}))) IN (LOWER('CA'), LOWER('OR'), LOWER('WA'), LOWER('NV'), LOWER('AZ')) THEN 'West' WHEN LOWER(UPPER(TRIM({{ state }}))) IN (LOWER('NY'), LOWER('NJ'), LOWER('MA'), LOWER('PA'), LOWER('CT')) THEN 'Northeast' WHEN LOWER(UPPER(TRIM({{ state }}))) IN (LOWER('TX'), LOWER('OK'), LOWER('LA'), LOWER('AR')) THEN 'South Central' ELSE 'Central' END

CASE WHEN LOWER(UPPER(TRIM({{ state }}))) IN (LOWER('CA'), LOWER('OR'), LOWER('WA'), LOWER('NV'), LOWER('AZ')) THEN 'West' WHEN LOWER(UPPER(TRIM({{ state }}))) IN (LOWER('NY'), LOWER('NJ'), LOWER('MA'), LOWER('PA'), LOWER('CT')) THEN 'Northeast' WHEN LOWER(UPPER(TRIM({{ state }}))) IN (LOWER('TX'), LOWER('OK'), LOWER('LA'), LOWER('AR')) THEN 'South Central' ELSE 'Central' END

(NOT (({{ total }} IS NULL)) AND {{ total }} >= {{ threshold }})

(NOT (({{ total }} IS NULL)) AND {{ total }} >= {{ threshold }})

(NOT (({{ total }} IS NULL)) AND {{ total }} >= {{ threshold }})

(NOT (({{ total }} IS NULL)) AND {{ total }} >= {{ threshold }})

(NOT (({{ total }} IS NULL)) AND {{ total }} >= {{ threshold }})

(NOT (({{ total }} IS NULL)) AND {{ total }} >= {{ threshold }})

(NOT (({{ total }} IS NULL)) AND {{ total }} >= {{ threshold }})

(NOT (({{ total }} IS NULL)) AND {{ total }} >= {{ threshold }})

CASE WHEN (({{ denominator }} IS NULL) OR {{ denominator }} = 0) THEN 0 ELSE {{ numerator }} / {{ denominator }} END

CASE WHEN (({{ denominator }} IS NULL) OR {{ denominator }} = 0) THEN 0 ELSE CAST({{ numerator }} AS BIGNUMERIC) / {{ denominator }} END

CASE WHEN (({{ denominator }} IS NULL) OR {{ denominator }} = 0) THEN 0 ELSE CAST({{ numerator }} AS DECIMAL(38, 10)) / {{ denominator }} END

CASE WHEN (({{ denominator }} IS NULL) OR {{ denominator }} = 0) THEN 0 ELSE CAST({{ numerator }} AS DECIMAL(38, 10)) / {{ denominator }} END

CASE WHEN (({{ denominator }} IS NULL) OR {{ denominator }} = 0) THEN 0 ELSE CAST({{ numerator }} AS NUMERIC) / {{ denominator }} END

CASE WHEN (({{ denominator }} IS NULL) OR {{ denominator }} = 0) THEN 0 ELSE CAST({{ numerator }} AS DECIMAL(38, 10)) / {{ denominator }} END

CASE WHEN (({{ denominator }} IS NULL) OR {{ denominator }} = 0) THEN 0 ELSE {{ numerator }} / {{ denominator }} END

CASE WHEN (({{ denominator }} IS NULL) OR {{ denominator }} = 0) THEN 0 ELSE {{ numerator }} / {{ denominator }} END

CONCAT('****', COALESCE(CAST(RIGHT(TRIM({{ account }}), 4) AS VARCHAR), ''))

CONCAT('****', COALESCE(CAST(RIGHT(TRIM({{ account }}), 4) AS STRING), ''))

CONCAT('****', COALESCE(CAST(RIGHT(TRIM({{ account }}), 4) AS STRING), ''))

('****' || COALESCE(CAST(RIGHT(TRIM({{ account }}), 4) AS VARCHAR), ''))

CONCAT('****', RIGHT(TRIM({{ account }}), 4))

CONCAT('****', RIGHT(TRIM({{ account }}), 4))

('****' || SUBSTR(TRIM({{ account }}), -4))

CONCAT('****', COALESCE(CAST(RIGHT(TRIM({{ account }}), 4) AS CHAR), ''))

CONCAT(COALESCE(CAST(UPPER(TRIM({{ prefix }})) AS VARCHAR), ''), '-', COALESCE(CAST(TRIM({{ number }}) AS VARCHAR), ''))

CONCAT(COALESCE(CAST(UPPER(TRIM({{ prefix }})) AS STRING), ''), '-', COALESCE(CAST(TRIM({{ number }}) AS STRING), ''))

CONCAT(COALESCE(CAST(UPPER(TRIM({{ prefix }})) AS STRING), ''), '-', COALESCE(CAST(TRIM({{ number }}) AS STRING), ''))

(COALESCE(CAST(UPPER(TRIM({{ prefix }})) AS VARCHAR), '') || '-' || COALESCE(CAST(TRIM({{ number }}) AS VARCHAR), ''))

CONCAT(UPPER(TRIM({{ prefix }})), '-', TRIM({{ number }}))

CONCAT(UPPER(TRIM({{ prefix }})), '-', TRIM({{ number }}))

(UPPER(TRIM({{ prefix }})) || '-' || TRIM({{ number }}))

CONCAT(COALESCE(CAST(UPPER(TRIM({{ prefix }})) AS CHAR), ''), '-', COALESCE(CAST(TRIM({{ number }}) AS CHAR), ''))

CASE WHEN EXTRACT(DAY FROM {{ day }}) <= 7 THEN 'Week 1' WHEN EXTRACT(DAY FROM {{ day }}) <= 14 THEN 'Week 2' WHEN EXTRACT(DAY FROM {{ day }}) <= 21 THEN 'Week 3' ELSE 'Week 4+' END

CASE WHEN EXTRACT(DAY FROM {{ day }}) <= 7 THEN 'Week 1' WHEN EXTRACT(DAY FROM {{ day }}) <= 14 THEN 'Week 2' WHEN EXTRACT(DAY FROM {{ day }}) <= 21 THEN 'Week 3' ELSE 'Week 4+' END

CASE WHEN EXTRACT(DAY FROM {{ day }}) <= 7 THEN 'Week 1' WHEN EXTRACT(DAY FROM {{ day }}) <= 14 THEN 'Week 2' WHEN EXTRACT(DAY FROM {{ day }}) <= 21 THEN 'Week 3' ELSE 'Week 4+' END

CASE WHEN EXTRACT(DAY FROM {{ day }}) <= 7 THEN 'Week 1' WHEN EXTRACT(DAY FROM {{ day }}) <= 14 THEN 'Week 2' WHEN EXTRACT(DAY FROM {{ day }}) <= 21 THEN 'Week 3' ELSE 'Week 4+' END

CASE WHEN EXTRACT(DAY FROM {{ day }}) <= 7 THEN 'Week 1' WHEN EXTRACT(DAY FROM {{ day }}) <= 14 THEN 'Week 2' WHEN EXTRACT(DAY FROM {{ day }}) <= 21 THEN 'Week 3' ELSE 'Week 4+' END

CASE WHEN DATEPART(day, {{ day }}) <= 7 THEN 'Week 1' WHEN DATEPART(day, {{ day }}) <= 14 THEN 'Week 2' WHEN DATEPART(day, {{ day }}) <= 21 THEN 'Week 3' ELSE 'Week 4+' END

CASE WHEN EXTRACT(DAY FROM {{ day }}) <= 7 THEN 'Week 1' WHEN EXTRACT(DAY FROM {{ day }}) <= 14 THEN 'Week 2' WHEN EXTRACT(DAY FROM {{ day }}) <= 21 THEN 'Week 3' ELSE 'Week 4+' END

CASE WHEN EXTRACT(DAY FROM {{ day }}) <= 7 THEN 'Week 1' WHEN EXTRACT(DAY FROM {{ day }}) <= 14 THEN 'Week 2' WHEN EXTRACT(DAY FROM {{ day }}) <= 21 THEN 'Week 3' ELSE 'Week 4+' END

EXTRACT(DAY FROM DATEADD(day, 1, {{ day }})) = 1

EXTRACT(DAY FROM DATE_ADD({{ day }}, INTERVAL 1 DAY)) = 1

EXTRACT(DAY FROM DATEADD(day, 1, {{ day }})) = 1

EXTRACT(DAY FROM ({{ day }} + (1) * INTERVAL '1 day')) = 1

EXTRACT(DAY FROM ({{ day }} + (1) * INTERVAL '1 day')) = 1

DATEPART(day, DATEADD(day, 1, {{ day }})) = 1

EXTRACT(DAY FROM ({{ day }} + NUMTODSINTERVAL(1, 'DAY'))) = 1

EXTRACT(DAY FROM DATE_ADD({{ day }}, INTERVAL 1 DAY)) = 1

DATEADD(day, 1 - EXTRACT(DAY FROM {{ day }}), {{ day }})

DATE_ADD({{ day }}, INTERVAL 1 - EXTRACT(DAY FROM {{ day }}) DAY)

DATEADD(day, 1 - EXTRACT(DAY FROM {{ day }}), {{ day }})

({{ day }} + (1 - EXTRACT(DAY FROM {{ day }})) * INTERVAL '1 day')

({{ day }} + (1 - EXTRACT(DAY FROM {{ day }})) * INTERVAL '1 day')

DATEADD(day, 1 - DATEPART(day, {{ day }}), {{ day }})

({{ day }} + NUMTODSINTERVAL(1 - EXTRACT(DAY FROM {{ day }}), 'DAY'))

DATE_ADD({{ day }}, INTERVAL 1 - EXTRACT(DAY FROM {{ day }}) DAY)

ROUND({{ gross }} - COALESCE({{ discount }}, 0) + COALESCE({{ tax }}, 0), 2)

ROUND({{ gross }} - COALESCE({{ discount }}, 0) + COALESCE({{ tax }}, 0), 2)

ROUND({{ gross }} - COALESCE({{ discount }}, 0) + COALESCE({{ tax }}, 0), 2)

ROUND({{ gross }} - COALESCE({{ discount }}, 0) + COALESCE({{ tax }}, 0), 2)

ROUND(CAST({{ gross }} - COALESCE({{ discount }}, 0) + COALESCE({{ tax }}, 0) AS NUMERIC), 2)

ROUND({{ gross }} - COALESCE({{ discount }}, 0) + COALESCE({{ tax }}, 0), 2)

ROUND({{ gross }} - COALESCE({{ discount }}, 0) + COALESCE({{ tax }}, 0), 2)

ROUND({{ gross }} - COALESCE({{ discount }}, 0) + COALESCE({{ tax }}, 0), 2)

CASE WHEN {{ qty }} = 0 THEN 0 ELSE ROUND({{ total }} / {{ qty }}, 2) END

CASE WHEN {{ qty }} = 0 THEN 0 ELSE ROUND(CAST({{ total }} AS BIGNUMERIC) / {{ qty }}, 2) END

CASE WHEN {{ qty }} = 0 THEN 0 ELSE ROUND(CAST({{ total }} AS DECIMAL(38, 10)) / {{ qty }}, 2) END

CASE WHEN {{ qty }} = 0 THEN 0 ELSE ROUND(CAST({{ total }} AS DECIMAL(38, 10)) / {{ qty }}, 2) END

CASE WHEN {{ qty }} = 0 THEN 0 ELSE ROUND(CAST(CAST({{ total }} AS NUMERIC) / {{ qty }} AS NUMERIC), 2) END

CASE WHEN {{ qty }} = 0 THEN 0 ELSE ROUND(CAST({{ total }} AS DECIMAL(38, 10)) / {{ qty }}, 2) END

CASE WHEN {{ qty }} = 0 THEN 0 ELSE ROUND({{ total }} / {{ qty }}, 2) END

CASE WHEN {{ qty }} = 0 THEN 0 ELSE ROUND({{ total }} / {{ qty }}, 2) END

UPPER(REPLACE(REPLACE(TRIM({{ sku }}), ' ', '-'), '_', '-'))

UPPER(REPLACE(REPLACE(TRIM({{ sku }}), ' ', '-'), '_', '-'))

UPPER(REPLACE(REPLACE(TRIM({{ sku }}), ' ', '-'), '_', '-'))

UPPER(REPLACE(REPLACE(TRIM({{ sku }}), ' ', '-'), '_', '-'))

UPPER(REPLACE(REPLACE(TRIM({{ sku }}), ' ', '-'), '_', '-'))

UPPER(REPLACE(REPLACE(TRIM({{ sku }}), ' ', '-'), '_', '-'))

UPPER(REPLACE(REPLACE(TRIM({{ sku }}), ' ', '-'), '_', '-'))

UPPER(REPLACE(REPLACE(TRIM({{ sku }}), ' ', '-'), '_', '-'))

REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM({{ phone }}), '(', ''), ')', ''), '-', ''), ' ', ''), '.', '')

REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM({{ phone }}), '(', ''), ')', ''), '-', ''), ' ', ''), '.', '')

REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM({{ phone }}), '(', ''), ')', ''), '-', ''), ' ', ''), '.', '')

REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM({{ phone }}), '(', ''), ')', ''), '-', ''), ' ', ''), '.', '')

REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM({{ phone }}), '(', ''), ')', ''), '-', ''), ' ', ''), '.', '')

REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM({{ phone }}), '(', ''), ')', ''), '-', ''), ' ', ''), '.', '')

REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM({{ phone }}), '(', ''), ')', ''), '-', ''), ' ', ''), '.', '')

REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM({{ phone }}), '(', ''), ')', ''), '-', ''), ' ', ''), '.', '')

LEFT((REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM(({{ phone }})), '(', ''), ')', ''), '-', ''), ' ', ''), '.', '')), 3)

LEFT((REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM(({{ phone }})), '(', ''), ')', ''), '-', ''), ' ', ''), '.', '')), 3)

LEFT((REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM(({{ phone }})), '(', ''), ')', ''), '-', ''), ' ', ''), '.', '')), 3)

LEFT((REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM(({{ phone }})), '(', ''), ')', ''), '-', ''), ' ', ''), '.', '')), 3)

LEFT((REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM(({{ phone }})), '(', ''), ')', ''), '-', ''), ' ', ''), '.', '')), 3)

LEFT((REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM(({{ phone }})), '(', ''), ')', ''), '-', ''), ' ', ''), '.', '')), 3)

SUBSTR((REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM(({{ phone }})), '(', ''), ')', ''), '-', ''), ' ', ''), '.', '')), 1, 3)

LEFT((REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM(({{ phone }})), '(', ''), ')', ''), '-', ''), ' ', ''), '.', '')), 3)

LOWER(LEFT(RIGHT((REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM(({{ phone }})), '(', ''), ')', ''), '-', ''), ' ', ''), '.', '')), 10), 3)) IN (LOWER('800'), LOWER('888'), LOWER('877'), LOWER('866'), LOWER('855'), LOWER('844'), LOWER('833'))

LOWER(LEFT(RIGHT((REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM(({{ phone }})), '(', ''), ')', ''), '-', ''), ' ', ''), '.', '')), 10), 3)) IN (LOWER('800'), LOWER('888'), LOWER('877'), LOWER('866'), LOWER('855'), LOWER('844'), LOWER('833'))

LOWER(LEFT(RIGHT((REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM(({{ phone }})), '(', ''), ')', ''), '-', ''), ' ', ''), '.', '')), 10), 3)) IN (LOWER('800'), LOWER('888'), LOWER('877'), LOWER('866'), LOWER('855'), LOWER('844'), LOWER('833'))

LOWER(LEFT(RIGHT((REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM(({{ phone }})), '(', ''), ')', ''), '-', ''), ' ', ''), '.', '')), 10), 3)) IN (LOWER('800'), LOWER('888'), LOWER('877'), LOWER('866'), LOWER('855'), LOWER('844'), LOWER('833'))

LOWER(LEFT(RIGHT((REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM(({{ phone }})), '(', ''), ')', ''), '-', ''), ' ', ''), '.', '')), 10), 3)) IN (LOWER('800'), LOWER('888'), LOWER('877'), LOWER('866'), LOWER('855'), LOWER('844'), LOWER('833'))

LOWER(LEFT(RIGHT((REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM(({{ phone }})), '(', ''), ')', ''), '-', ''), ' ', ''), '.', '')), 10), 3)) IN (LOWER('800'), LOWER('888'), LOWER('877'), LOWER('866'), LOWER('855'), LOWER('844'), LOWER('833'))

LOWER(SUBSTR(SUBSTR((REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM(({{ phone }})), '(', ''), ')', ''), '-', ''), ' ', ''), '.', '')), -10), 1, 3)) IN (LOWER('800'), LOWER('888'), LOWER('877'), LOWER('866'), LOWER('855'), LOWER('844'), LOWER('833'))

LOWER(LEFT(RIGHT((REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM(({{ phone }})), '(', ''), ')', ''), '-', ''), ' ', ''), '.', '')), 10), 3)) IN (LOWER('800'), LOWER('888'), LOWER('877'), LOWER('866'), LOWER('855'), LOWER('844'), LOWER('833'))

CASE WHEN {{ flag }} THEN 'Yes' ELSE 'No' END

CASE WHEN {{ flag }} THEN 'Yes' ELSE 'No' END

CASE WHEN {{ flag }} THEN 'Yes' ELSE 'No' END

CASE WHEN {{ flag }} THEN 'Yes' ELSE 'No' END

CASE WHEN {{ flag }} THEN 'Yes' ELSE 'No' END

CASE WHEN {{ flag }} THEN 'Yes' ELSE 'No' END

CASE WHEN {{ flag }} THEN 'Yes' ELSE 'No' END

CASE WHEN {{ flag }} THEN 'Yes' ELSE 'No' END

CASE WHEN {{ code }} = 'A' THEN 'Active' WHEN {{ code }} = 'P' THEN 'Paused' WHEN {{ code }} = 'C' THEN 'Cancelled' ELSE 'Unknown' END

CASE WHEN {{ code }} = 'A' THEN 'Active' WHEN {{ code }} = 'P' THEN 'Paused' WHEN {{ code }} = 'C' THEN 'Cancelled' ELSE 'Unknown' END

CASE WHEN {{ code }} = 'A' THEN 'Active' WHEN {{ code }} = 'P' THEN 'Paused' WHEN {{ code }} = 'C' THEN 'Cancelled' ELSE 'Unknown' END

CASE WHEN {{ code }} = 'A' THEN 'Active' WHEN {{ code }} = 'P' THEN 'Paused' WHEN {{ code }} = 'C' THEN 'Cancelled' ELSE 'Unknown' END

CASE WHEN {{ code }} = 'A' THEN 'Active' WHEN {{ code }} = 'P' THEN 'Paused' WHEN {{ code }} = 'C' THEN 'Cancelled' ELSE 'Unknown' END

CASE WHEN {{ code }} = 'A' THEN 'Active' WHEN {{ code }} = 'P' THEN 'Paused' WHEN {{ code }} = 'C' THEN 'Cancelled' ELSE 'Unknown' END

CASE WHEN {{ code }} = 'A' THEN 'Active' WHEN {{ code }} = 'P' THEN 'Paused' WHEN {{ code }} = 'C' THEN 'Cancelled' ELSE 'Unknown' END

CASE WHEN {{ code }} = 'A' THEN 'Active' WHEN {{ code }} = 'P' THEN 'Paused' WHEN {{ code }} = 'C' THEN 'Cancelled' ELSE 'Unknown' END

ROUND({{ celsius }} * 9 / 5 + 32, 1)

ROUND(CAST({{ celsius }} * 9 AS BIGNUMERIC) / 5 + 32, 1)

ROUND(CAST({{ celsius }} * 9 AS DECIMAL(38, 10)) / 5 + 32, 1)

ROUND(CAST({{ celsius }} * 9 AS DECIMAL(38, 10)) / 5 + 32, 1)

ROUND(CAST(CAST({{ celsius }} * 9 AS NUMERIC) / 5 + 32 AS NUMERIC), 1)

ROUND(CAST({{ celsius }} * 9 AS DECIMAL(38, 10)) / 5 + 32, 1)

ROUND({{ celsius }} * 9 / 5 + 32, 1)

ROUND({{ celsius }} * 9 / 5 + 32, 1)

ROUND({{ kg }} * 2.20462, 2)

ROUND({{ kg }} * BIGNUMERIC '2.20462', 2)

ROUND({{ kg }} * 2.20462, 2)

ROUND({{ kg }} * 2.20462, 2)

ROUND(CAST({{ kg }} * 2.20462 AS NUMERIC), 2)

ROUND({{ kg }} * 2.20462, 2)

ROUND({{ kg }} * 2.20462, 2)

ROUND({{ kg }} * 2.20462, 2)

DATEADD(day, 30, CAST({{ order_day }} AS DATE)) >= CAST({{ as_of }} AS DATE)

DATE_ADD(CAST({{ order_day }} AS DATE), INTERVAL 30 DAY) >= CAST({{ as_of }} AS DATE)

DATEADD(day, 30, CAST({{ order_day }} AS DATE)) >= CAST({{ as_of }} AS DATE)

(CAST({{ order_day }} AS DATE) + (30) * INTERVAL '1 day') >= CAST({{ as_of }} AS DATE)

(CAST({{ order_day }} AS DATE) + (30) * INTERVAL '1 day') >= CAST({{ as_of }} AS DATE)

DATEADD(day, 30, CAST({{ order_day }} AS DATE)) >= CAST({{ as_of }} AS DATE)

(CAST({{ order_day }} AS DATE) + NUMTODSINTERVAL(30, 'DAY')) >= CAST({{ as_of }} AS DATE)

DATE_ADD(CAST({{ order_day }} AS DATE), INTERVAL 30 DAY) >= CAST({{ as_of }} AS DATE)

(EXTRACT(YEAR FROM {{ to_day }}) - EXTRACT(YEAR FROM {{ from_day }})) * 12 + EXTRACT(MONTH FROM {{ to_day }}) - EXTRACT(MONTH FROM {{ from_day }})

(EXTRACT(YEAR FROM {{ to_day }}) - EXTRACT(YEAR FROM {{ from_day }})) * 12 + EXTRACT(MONTH FROM {{ to_day }}) - EXTRACT(MONTH FROM {{ from_day }})

(EXTRACT(YEAR FROM {{ to_day }}) - EXTRACT(YEAR FROM {{ from_day }})) * 12 + EXTRACT(MONTH FROM {{ to_day }}) - EXTRACT(MONTH FROM {{ from_day }})

(EXTRACT(YEAR FROM {{ to_day }}) - EXTRACT(YEAR FROM {{ from_day }})) * 12 + EXTRACT(MONTH FROM {{ to_day }}) - EXTRACT(MONTH FROM {{ from_day }})

(EXTRACT(YEAR FROM {{ to_day }}) - EXTRACT(YEAR FROM {{ from_day }})) * 12 + EXTRACT(MONTH FROM {{ to_day }}) - EXTRACT(MONTH FROM {{ from_day }})

(DATEPART(year, {{ to_day }}) - DATEPART(year, {{ from_day }})) * 12 + DATEPART(month, {{ to_day }}) - DATEPART(month, {{ from_day }})

(EXTRACT(YEAR FROM {{ to_day }}) - EXTRACT(YEAR FROM {{ from_day }})) * 12 + EXTRACT(MONTH FROM {{ to_day }}) - EXTRACT(MONTH FROM {{ from_day }})

(EXTRACT(YEAR FROM {{ to_day }}) - EXTRACT(YEAR FROM {{ from_day }})) * 12 + EXTRACT(MONTH FROM {{ to_day }}) - EXTRACT(MONTH FROM {{ from_day }})

EXTRACT(YEAR FROM {{ day }}) * 100 + EXTRACT(MONTH FROM {{ day }})

EXTRACT(YEAR FROM {{ day }}) * 100 + EXTRACT(MONTH FROM {{ day }})

EXTRACT(YEAR FROM {{ day }}) * 100 + EXTRACT(MONTH FROM {{ day }})

EXTRACT(YEAR FROM {{ day }}) * 100 + EXTRACT(MONTH FROM {{ day }})

EXTRACT(YEAR FROM {{ day }}) * 100 + EXTRACT(MONTH FROM {{ day }})

DATEPART(year, {{ day }}) * 100 + DATEPART(month, {{ day }})

EXTRACT(YEAR FROM {{ day }}) * 100 + EXTRACT(MONTH FROM {{ day }})

EXTRACT(YEAR FROM {{ day }}) * 100 + EXTRACT(MONTH FROM {{ day }})

CASE WHEN (LOWER({{ ship_method }}) = 'overnight' OR {{ total }} >= 1000) THEN 'P1' WHEN ({{ is_member }} AND {{ total }} >= 250) THEN 'P2' ELSE 'P3' END

CASE WHEN (LOWER({{ ship_method }}) = 'overnight' OR {{ total }} >= 1000) THEN 'P1' WHEN ({{ is_member }} AND {{ total }} >= 250) THEN 'P2' ELSE 'P3' END

CASE WHEN (LOWER({{ ship_method }}) = 'overnight' OR {{ total }} >= 1000) THEN 'P1' WHEN ({{ is_member }} AND {{ total }} >= 250) THEN 'P2' ELSE 'P3' END

CASE WHEN (LOWER({{ ship_method }}) = 'overnight' OR {{ total }} >= 1000) THEN 'P1' WHEN ({{ is_member }} AND {{ total }} >= 250) THEN 'P2' ELSE 'P3' END

CASE WHEN (LOWER({{ ship_method }}) = 'overnight' OR {{ total }} >= 1000) THEN 'P1' WHEN ({{ is_member }} AND {{ total }} >= 250) THEN 'P2' ELSE 'P3' END

CASE WHEN (LOWER({{ ship_method }}) = 'overnight' OR {{ total }} >= 1000) THEN 'P1' WHEN ({{ is_member }} AND {{ total }} >= 250) THEN 'P2' ELSE 'P3' END

CASE WHEN (LOWER({{ ship_method }}) = 'overnight' OR {{ total }} >= 1000) THEN 'P1' WHEN ({{ is_member }} AND {{ total }} >= 250) THEN 'P2' ELSE 'P3' END

CASE WHEN (LOWER({{ ship_method }}) = 'overnight' OR {{ total }} >= 1000) THEN 'P1' WHEN ({{ is_member }} AND {{ total }} >= 250) THEN 'P2' ELSE 'P3' END

CASE WHEN ({{ lifetime_spend }} >= 5000 AND {{ orders }} >= 20) THEN 'Platinum' WHEN {{ lifetime_spend }} >= 2000 THEN 'Gold' WHEN {{ orders }} >= 3 THEN 'Silver' ELSE 'Bronze' END

CASE WHEN ({{ lifetime_spend }} >= 5000 AND {{ orders }} >= 20) THEN 'Platinum' WHEN {{ lifetime_spend }} >= 2000 THEN 'Gold' WHEN {{ orders }} >= 3 THEN 'Silver' ELSE 'Bronze' END

CASE WHEN ({{ lifetime_spend }} >= 5000 AND {{ orders }} >= 20) THEN 'Platinum' WHEN {{ lifetime_spend }} >= 2000 THEN 'Gold' WHEN {{ orders }} >= 3 THEN 'Silver' ELSE 'Bronze' END

CASE WHEN ({{ lifetime_spend }} >= 5000 AND {{ orders }} >= 20) THEN 'Platinum' WHEN {{ lifetime_spend }} >= 2000 THEN 'Gold' WHEN {{ orders }} >= 3 THEN 'Silver' ELSE 'Bronze' END

CASE WHEN ({{ lifetime_spend }} >= 5000 AND {{ orders }} >= 20) THEN 'Platinum' WHEN {{ lifetime_spend }} >= 2000 THEN 'Gold' WHEN {{ orders }} >= 3 THEN 'Silver' ELSE 'Bronze' END

CASE WHEN ({{ lifetime_spend }} >= 5000 AND {{ orders }} >= 20) THEN 'Platinum' WHEN {{ lifetime_spend }} >= 2000 THEN 'Gold' WHEN {{ orders }} >= 3 THEN 'Silver' ELSE 'Bronze' END

CASE WHEN ({{ lifetime_spend }} >= 5000 AND {{ orders }} >= 20) THEN 'Platinum' WHEN {{ lifetime_spend }} >= 2000 THEN 'Gold' WHEN {{ orders }} >= 3 THEN 'Silver' ELSE 'Bronze' END

CASE WHEN ({{ lifetime_spend }} >= 5000 AND {{ orders }} >= 20) THEN 'Platinum' WHEN {{ lifetime_spend }} >= 2000 THEN 'Gold' WHEN {{ orders }} >= 3 THEN 'Silver' ELSE 'Bronze' END

CASE WHEN ({{ email }} IS NULL) THEN CONCAT('phone:', COALESCE(CAST((REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM(({{ phone }})), '(', ''), ')', ''), '-', ''), ' ', ''), '.', '')) AS VARCHAR), '')) ELSE CONCAT('email:', COALESCE(CAST((LOWER(TRIM(({{ email }})))) AS VARCHAR), '')) END

CASE WHEN ({{ email }} IS NULL) THEN CONCAT('phone:', COALESCE(CAST((REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM(({{ phone }})), '(', ''), ')', ''), '-', ''), ' ', ''), '.', '')) AS STRING), '')) ELSE CONCAT('email:', COALESCE(CAST((LOWER(TRIM(({{ email }})))) AS STRING), '')) END

CASE WHEN ({{ email }} IS NULL) THEN CONCAT('phone:', COALESCE(CAST((REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM(({{ phone }})), '(', ''), ')', ''), '-', ''), ' ', ''), '.', '')) AS STRING), '')) ELSE CONCAT('email:', COALESCE(CAST((LOWER(TRIM(({{ email }})))) AS STRING), '')) END

CASE WHEN ({{ email }} IS NULL) THEN ('phone:' || COALESCE(CAST((REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM(({{ phone }})), '(', ''), ')', ''), '-', ''), ' ', ''), '.', '')) AS VARCHAR), '')) ELSE ('email:' || COALESCE(CAST((LOWER(TRIM(({{ email }})))) AS VARCHAR), '')) END

CASE WHEN ({{ email }} IS NULL) THEN CONCAT('phone:', (REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM(({{ phone }})), '(', ''), ')', ''), '-', ''), ' ', ''), '.', ''))) ELSE CONCAT('email:', (LOWER(TRIM(({{ email }}))))) END

CASE WHEN ({{ email }} IS NULL) THEN CONCAT('phone:', (REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM(({{ phone }})), '(', ''), ')', ''), '-', ''), ' ', ''), '.', ''))) ELSE CONCAT('email:', (LOWER(TRIM(({{ email }}))))) END

CASE WHEN ({{ email }} IS NULL) THEN ('phone:' || (REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM(({{ phone }})), '(', ''), ')', ''), '-', ''), ' ', ''), '.', ''))) ELSE ('email:' || (LOWER(TRIM(({{ email }}))))) END

CASE WHEN ({{ email }} IS NULL) THEN CONCAT('phone:', COALESCE(CAST((REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM(({{ phone }})), '(', ''), ')', ''), '-', ''), ' ', ''), '.', '')) AS CHAR), '')) ELSE CONCAT('email:', COALESCE(CAST((LOWER(TRIM(({{ email }})))) AS CHAR), '')) END

CASE WHEN ({{ company }} IS NULL) THEN (CONCAT(COALESCE(CAST(TRIM(((CONCAT(COALESCE(CAST(UPPER(LEFT(TRIM(({{ first }})), 1)) AS VARCHAR), ''), COALESCE(CAST(LOWER(SUBSTRING(TRIM(({{ first }})), 2, LENGTH(TRIM(({{ first }}))))) AS VARCHAR), ''))))) AS VARCHAR), ''), ' ', COALESCE(CAST(TRIM(((CONCAT(COALESCE(CAST(UPPER(LEFT(TRIM(({{ last }})), 1)) AS VARCHAR), ''), COALESCE(CAST(LOWER(SUBSTRING(TRIM(({{ last }})), 2, LENGTH(TRIM(({{ last }}))))) AS VARCHAR), ''))))) AS VARCHAR), ''))) ELSE TRIM({{ company }}) END

CASE WHEN ({{ company }} IS NULL) THEN (CONCAT(COALESCE(CAST(TRIM(((CONCAT(COALESCE(CAST(UPPER(LEFT(TRIM(({{ first }})), 1)) AS STRING), ''), COALESCE(CAST(LOWER(SUBSTR(TRIM(({{ first }})), 2, LENGTH(TRIM(({{ first }}))))) AS STRING), ''))))) AS STRING), ''), ' ', COALESCE(CAST(TRIM(((CONCAT(COALESCE(CAST(UPPER(LEFT(TRIM(({{ last }})), 1)) AS STRING), ''), COALESCE(CAST(LOWER(SUBSTR(TRIM(({{ last }})), 2, LENGTH(TRIM(({{ last }}))))) AS STRING), ''))))) AS STRING), ''))) ELSE TRIM({{ company }}) END

CASE WHEN ({{ company }} IS NULL) THEN (CONCAT(COALESCE(CAST(TRIM(((CONCAT(COALESCE(CAST(UPPER(LEFT(TRIM(({{ first }})), 1)) AS STRING), ''), COALESCE(CAST(LOWER(SUBSTRING(TRIM(({{ first }})), 2, LENGTH(TRIM(({{ first }}))))) AS STRING), ''))))) AS STRING), ''), ' ', COALESCE(CAST(TRIM(((CONCAT(COALESCE(CAST(UPPER(LEFT(TRIM(({{ last }})), 1)) AS STRING), ''), COALESCE(CAST(LOWER(SUBSTRING(TRIM(({{ last }})), 2, LENGTH(TRIM(({{ last }}))))) AS STRING), ''))))) AS STRING), ''))) ELSE TRIM({{ company }}) END

CASE WHEN ({{ company }} IS NULL) THEN ((COALESCE(CAST(TRIM((((COALESCE(CAST(UPPER(LEFT(TRIM(({{ first }})), 1)) AS VARCHAR), '') || COALESCE(CAST(LOWER(SUBSTRING(TRIM(({{ first }})), 2, LENGTH(TRIM(({{ first }}))))) AS VARCHAR), ''))))) AS VARCHAR), '') || ' ' || COALESCE(CAST(TRIM((((COALESCE(CAST(UPPER(LEFT(TRIM(({{ last }})), 1)) AS VARCHAR), '') || COALESCE(CAST(LOWER(SUBSTRING(TRIM(({{ last }})), 2, LENGTH(TRIM(({{ last }}))))) AS VARCHAR), ''))))) AS VARCHAR), ''))) ELSE TRIM({{ company }}) END

CASE WHEN ({{ company }} IS NULL) THEN (CONCAT(TRIM(((CONCAT(UPPER(LEFT(TRIM(({{ first }})), 1)), LOWER(SUBSTRING(TRIM(({{ first }})), 2, LENGTH(TRIM(({{ first }}))))))))), ' ', TRIM(((CONCAT(UPPER(LEFT(TRIM(({{ last }})), 1)), LOWER(SUBSTRING(TRIM(({{ last }})), 2, LENGTH(TRIM(({{ last }}))))))))))) ELSE TRIM({{ company }}) END

CASE WHEN ({{ company }} IS NULL) THEN (CONCAT(TRIM(((CONCAT(UPPER(LEFT(TRIM(({{ first }})), 1)), LOWER(SUBSTRING(TRIM(({{ first }})), 2, LEN(TRIM(({{ first }}))))))))), ' ', TRIM(((CONCAT(UPPER(LEFT(TRIM(({{ last }})), 1)), LOWER(SUBSTRING(TRIM(({{ last }})), 2, LEN(TRIM(({{ last }}))))))))))) ELSE TRIM({{ company }}) END

CASE WHEN ({{ company }} IS NULL) THEN ((TRIM((((UPPER(SUBSTR(TRIM(({{ first }})), 1, 1)) || LOWER(SUBSTR(TRIM(({{ first }})), 2, LENGTH(TRIM(({{ first }}))))))))) || ' ' || TRIM((((UPPER(SUBSTR(TRIM(({{ last }})), 1, 1)) || LOWER(SUBSTR(TRIM(({{ last }})), 2, LENGTH(TRIM(({{ last }}))))))))))) ELSE TRIM({{ company }}) END

CASE WHEN ({{ company }} IS NULL) THEN (CONCAT(COALESCE(CAST(TRIM(((CONCAT(COALESCE(CAST(UPPER(LEFT(TRIM(({{ first }})), 1)) AS CHAR), ''), COALESCE(CAST(LOWER(SUBSTRING(TRIM(({{ first }})), 2, CHAR_LENGTH(TRIM(({{ first }}))))) AS CHAR), ''))))) AS CHAR), ''), ' ', COALESCE(CAST(TRIM(((CONCAT(COALESCE(CAST(UPPER(LEFT(TRIM(({{ last }})), 1)) AS CHAR), ''), COALESCE(CAST(LOWER(SUBSTRING(TRIM(({{ last }})), 2, CHAR_LENGTH(TRIM(({{ last }}))))) AS CHAR), ''))))) AS CHAR), ''))) ELSE TRIM({{ company }}) END

ROUND({{ amount }} * CASE WHEN UPPER({{ state }}) = 'CA' THEN 0.0725 WHEN UPPER({{ state }}) = 'TX' THEN 0.0625 WHEN UPPER({{ state }}) = 'NY' THEN 0.04 WHEN LOWER(UPPER({{ state }})) IN (LOWER('OR'), LOWER('MT'), LOWER('NH'), LOWER('DE')) THEN 0 ELSE 0.05 END, 2)

ROUND({{ amount }} * CASE WHEN UPPER({{ state }}) = 'CA' THEN BIGNUMERIC '0.0725' WHEN UPPER({{ state }}) = 'TX' THEN BIGNUMERIC '0.0625' WHEN UPPER({{ state }}) = 'NY' THEN BIGNUMERIC '0.04' WHEN LOWER(UPPER({{ state }})) IN (LOWER('OR'), LOWER('MT'), LOWER('NH'), LOWER('DE')) THEN 0 ELSE BIGNUMERIC '0.05' END, 2)

ROUND({{ amount }} * CASE WHEN UPPER({{ state }}) = 'CA' THEN 0.0725 WHEN UPPER({{ state }}) = 'TX' THEN 0.0625 WHEN UPPER({{ state }}) = 'NY' THEN 0.04 WHEN LOWER(UPPER({{ state }})) IN (LOWER('OR'), LOWER('MT'), LOWER('NH'), LOWER('DE')) THEN 0 ELSE 0.05 END, 2)

ROUND({{ amount }} * CASE WHEN UPPER({{ state }}) = 'CA' THEN 0.0725 WHEN UPPER({{ state }}) = 'TX' THEN 0.0625 WHEN UPPER({{ state }}) = 'NY' THEN 0.04 WHEN LOWER(UPPER({{ state }})) IN (LOWER('OR'), LOWER('MT'), LOWER('NH'), LOWER('DE')) THEN 0 ELSE 0.05 END, 2)

ROUND(CAST({{ amount }} * CASE WHEN UPPER({{ state }}) = 'CA' THEN 0.0725 WHEN UPPER({{ state }}) = 'TX' THEN 0.0625 WHEN UPPER({{ state }}) = 'NY' THEN 0.04 WHEN LOWER(UPPER({{ state }})) IN (LOWER('OR'), LOWER('MT'), LOWER('NH'), LOWER('DE')) THEN 0 ELSE 0.05 END AS NUMERIC), 2)

ROUND({{ amount }} * CASE WHEN UPPER({{ state }}) = 'CA' THEN 0.0725 WHEN UPPER({{ state }}) = 'TX' THEN 0.0625 WHEN UPPER({{ state }}) = 'NY' THEN 0.04 WHEN LOWER(UPPER({{ state }})) IN (LOWER('OR'), LOWER('MT'), LOWER('NH'), LOWER('DE')) THEN 0 ELSE 0.05 END, 2)

ROUND({{ amount }} * CASE WHEN UPPER({{ state }}) = 'CA' THEN 0.0725 WHEN UPPER({{ state }}) = 'TX' THEN 0.0625 WHEN UPPER({{ state }}) = 'NY' THEN 0.04 WHEN LOWER(UPPER({{ state }})) IN (LOWER('OR'), LOWER('MT'), LOWER('NH'), LOWER('DE')) THEN 0 ELSE 0.05 END, 2)

ROUND({{ amount }} * CASE WHEN UPPER({{ state }}) = 'CA' THEN 0.0725 WHEN UPPER({{ state }}) = 'TX' THEN 0.0625 WHEN UPPER({{ state }}) = 'NY' THEN 0.04 WHEN LOWER(UPPER({{ state }})) IN (LOWER('OR'), LOWER('MT'), LOWER('NH'), LOWER('DE')) THEN 0 ELSE 0.05 END, 2)

CASE WHEN {{ is_member }} THEN 0 ELSE ROUND((CASE WHEN ({{ weight_lb }}) <= 1 THEN 5.95 WHEN ({{ weight_lb }}) <= 5 THEN 9.95 ELSE 14.95 END) * CASE WHEN {{ zone }} >= 7 THEN 1.5 WHEN {{ zone }} >= 4 THEN 1.2 ELSE 1 END, 2) END

CASE WHEN {{ is_member }} THEN 0 ELSE ROUND((CASE WHEN ({{ weight_lb }}) <= 1 THEN BIGNUMERIC '5.95' WHEN ({{ weight_lb }}) <= 5 THEN BIGNUMERIC '9.95' ELSE BIGNUMERIC '14.95' END) * CASE WHEN {{ zone }} >= 7 THEN BIGNUMERIC '1.5' WHEN {{ zone }} >= 4 THEN BIGNUMERIC '1.2' ELSE 1 END, 2) END

CASE WHEN {{ is_member }} THEN 0 ELSE ROUND((CASE WHEN ({{ weight_lb }}) <= 1 THEN 5.95 WHEN ({{ weight_lb }}) <= 5 THEN 9.95 ELSE 14.95 END) * CASE WHEN {{ zone }} >= 7 THEN 1.5 WHEN {{ zone }} >= 4 THEN 1.2 ELSE 1 END, 2) END

CASE WHEN {{ is_member }} THEN 0 ELSE ROUND((CASE WHEN ({{ weight_lb }}) <= 1 THEN 5.95 WHEN ({{ weight_lb }}) <= 5 THEN 9.95 ELSE 14.95 END) * CASE WHEN {{ zone }} >= 7 THEN 1.5 WHEN {{ zone }} >= 4 THEN 1.2 ELSE 1 END, 2) END

CASE WHEN {{ is_member }} THEN 0 ELSE ROUND(CAST((CASE WHEN ({{ weight_lb }}) <= 1 THEN 5.95 WHEN ({{ weight_lb }}) <= 5 THEN 9.95 ELSE 14.95 END) * CASE WHEN {{ zone }} >= 7 THEN 1.5 WHEN {{ zone }} >= 4 THEN 1.2 ELSE 1 END AS NUMERIC), 2) END

CASE WHEN {{ is_member }} THEN 0 ELSE ROUND((CASE WHEN ({{ weight_lb }}) <= 1 THEN 5.95 WHEN ({{ weight_lb }}) <= 5 THEN 9.95 ELSE 14.95 END) * CASE WHEN {{ zone }} >= 7 THEN 1.5 WHEN {{ zone }} >= 4 THEN 1.2 ELSE 1 END, 2) END

CASE WHEN {{ is_member }} THEN 0 ELSE ROUND((CASE WHEN ({{ weight_lb }}) <= 1 THEN 5.95 WHEN ({{ weight_lb }}) <= 5 THEN 9.95 ELSE 14.95 END) * CASE WHEN {{ zone }} >= 7 THEN 1.5 WHEN {{ zone }} >= 4 THEN 1.2 ELSE 1 END, 2) END

CASE WHEN {{ is_member }} THEN 0 ELSE ROUND((CASE WHEN ({{ weight_lb }}) <= 1 THEN 5.95 WHEN ({{ weight_lb }}) <= 5 THEN 9.95 ELSE 14.95 END) * CASE WHEN {{ zone }} >= 7 THEN 1.5 WHEN {{ zone }} >= 4 THEN 1.2 ELSE 1 END, 2) END

CASE WHEN {{ subtotal }} >= {{ threshold }} THEN 0 ELSE ROUND({{ threshold }} - {{ subtotal }}, 2) END

CASE WHEN {{ subtotal }} >= {{ threshold }} THEN 0 ELSE ROUND({{ threshold }} - {{ subtotal }}, 2) END

CASE WHEN {{ subtotal }} >= {{ threshold }} THEN 0 ELSE ROUND({{ threshold }} - {{ subtotal }}, 2) END

CASE WHEN {{ subtotal }} >= {{ threshold }} THEN 0 ELSE ROUND({{ threshold }} - {{ subtotal }}, 2) END

CASE WHEN {{ subtotal }} >= {{ threshold }} THEN 0 ELSE ROUND(CAST({{ threshold }} - {{ subtotal }} AS NUMERIC), 2) END

CASE WHEN {{ subtotal }} >= {{ threshold }} THEN 0 ELSE ROUND({{ threshold }} - {{ subtotal }}, 2) END

CASE WHEN {{ subtotal }} >= {{ threshold }} THEN 0 ELSE ROUND({{ threshold }} - {{ subtotal }}, 2) END

CASE WHEN {{ subtotal }} >= {{ threshold }} THEN 0 ELSE ROUND({{ threshold }} - {{ subtotal }}, 2) END

ROUND(CASE WHEN {{ sales }} <= 10000 THEN {{ sales }} * 0.05 WHEN {{ sales }} <= 50000 THEN 500 + ({{ sales }} - 10000) * 0.07 ELSE 3300 + ({{ sales }} - 50000) * 0.1 END, 2)

ROUND(CASE WHEN {{ sales }} <= 10000 THEN {{ sales }} * BIGNUMERIC '0.05' WHEN {{ sales }} <= 50000 THEN 500 + ({{ sales }} - 10000) * BIGNUMERIC '0.07' ELSE 3300 + ({{ sales }} - 50000) * BIGNUMERIC '0.1' END, 2)

ROUND(CASE WHEN {{ sales }} <= 10000 THEN {{ sales }} * 0.05 WHEN {{ sales }} <= 50000 THEN 500 + ({{ sales }} - 10000) * 0.07 ELSE 3300 + ({{ sales }} - 50000) * 0.1 END, 2)

ROUND(CASE WHEN {{ sales }} <= 10000 THEN {{ sales }} * 0.05 WHEN {{ sales }} <= 50000 THEN 500 + ({{ sales }} - 10000) * 0.07 ELSE 3300 + ({{ sales }} - 50000) * 0.1 END, 2)

ROUND(CAST(CASE WHEN {{ sales }} <= 10000 THEN {{ sales }} * 0.05 WHEN {{ sales }} <= 50000 THEN 500 + ({{ sales }} - 10000) * 0.07 ELSE 3300 + ({{ sales }} - 50000) * 0.1 END AS NUMERIC), 2)

ROUND(CASE WHEN {{ sales }} <= 10000 THEN {{ sales }} * 0.05 WHEN {{ sales }} <= 50000 THEN 500 + ({{ sales }} - 10000) * 0.07 ELSE 3300 + ({{ sales }} - 50000) * 0.1 END, 2)

ROUND(CASE WHEN {{ sales }} <= 10000 THEN {{ sales }} * 0.05 WHEN {{ sales }} <= 50000 THEN 500 + ({{ sales }} - 10000) * 0.07 ELSE 3300 + ({{ sales }} - 50000) * 0.1 END, 2)

ROUND(CASE WHEN {{ sales }} <= 10000 THEN {{ sales }} * 0.05 WHEN {{ sales }} <= 50000 THEN 500 + ({{ sales }} - 10000) * 0.07 ELSE 3300 + ({{ sales }} - 50000) * 0.1 END, 2)

CASE WHEN CAST({{ due_day }} AS DATE) >= CAST({{ as_of }} AS DATE) THEN 'Current' WHEN DATEADD(day, 30, CAST({{ due_day }} AS DATE)) >= CAST({{ as_of }} AS DATE) THEN '1-30' WHEN DATEADD(day, 60, CAST({{ due_day }} AS DATE)) >= CAST({{ as_of }} AS DATE) THEN '31-60' WHEN DATEADD(day, 90, CAST({{ due_day }} AS DATE)) >= CAST({{ as_of }} AS DATE) THEN '61-90' ELSE '90+' END

CASE WHEN CAST({{ due_day }} AS DATE) >= CAST({{ as_of }} AS DATE) THEN 'Current' WHEN DATE_ADD(CAST({{ due_day }} AS DATE), INTERVAL 30 DAY) >= CAST({{ as_of }} AS DATE) THEN '1-30' WHEN DATE_ADD(CAST({{ due_day }} AS DATE), INTERVAL 60 DAY) >= CAST({{ as_of }} AS DATE) THEN '31-60' WHEN DATE_ADD(CAST({{ due_day }} AS DATE), INTERVAL 90 DAY) >= CAST({{ as_of }} AS DATE) THEN '61-90' ELSE '90+' END

CASE WHEN CAST({{ due_day }} AS DATE) >= CAST({{ as_of }} AS DATE) THEN 'Current' WHEN DATEADD(day, 30, CAST({{ due_day }} AS DATE)) >= CAST({{ as_of }} AS DATE) THEN '1-30' WHEN DATEADD(day, 60, CAST({{ due_day }} AS DATE)) >= CAST({{ as_of }} AS DATE) THEN '31-60' WHEN DATEADD(day, 90, CAST({{ due_day }} AS DATE)) >= CAST({{ as_of }} AS DATE) THEN '61-90' ELSE '90+' END

CASE WHEN CAST({{ due_day }} AS DATE) >= CAST({{ as_of }} AS DATE) THEN 'Current' WHEN (CAST({{ due_day }} AS DATE) + (30) * INTERVAL '1 day') >= CAST({{ as_of }} AS DATE) THEN '1-30' WHEN (CAST({{ due_day }} AS DATE) + (60) * INTERVAL '1 day') >= CAST({{ as_of }} AS DATE) THEN '31-60' WHEN (CAST({{ due_day }} AS DATE) + (90) * INTERVAL '1 day') >= CAST({{ as_of }} AS DATE) THEN '61-90' ELSE '90+' END

CASE WHEN CAST({{ due_day }} AS DATE) >= CAST({{ as_of }} AS DATE) THEN 'Current' WHEN (CAST({{ due_day }} AS DATE) + (30) * INTERVAL '1 day') >= CAST({{ as_of }} AS DATE) THEN '1-30' WHEN (CAST({{ due_day }} AS DATE) + (60) * INTERVAL '1 day') >= CAST({{ as_of }} AS DATE) THEN '31-60' WHEN (CAST({{ due_day }} AS DATE) + (90) * INTERVAL '1 day') >= CAST({{ as_of }} AS DATE) THEN '61-90' ELSE '90+' END

CASE WHEN CAST({{ due_day }} AS DATE) >= CAST({{ as_of }} AS DATE) THEN 'Current' WHEN DATEADD(day, 30, CAST({{ due_day }} AS DATE)) >= CAST({{ as_of }} AS DATE) THEN '1-30' WHEN DATEADD(day, 60, CAST({{ due_day }} AS DATE)) >= CAST({{ as_of }} AS DATE) THEN '31-60' WHEN DATEADD(day, 90, CAST({{ due_day }} AS DATE)) >= CAST({{ as_of }} AS DATE) THEN '61-90' ELSE '90+' END

CASE WHEN CAST({{ due_day }} AS DATE) >= CAST({{ as_of }} AS DATE) THEN 'Current' WHEN (CAST({{ due_day }} AS DATE) + NUMTODSINTERVAL(30, 'DAY')) >= CAST({{ as_of }} AS DATE) THEN '1-30' WHEN (CAST({{ due_day }} AS DATE) + NUMTODSINTERVAL(60, 'DAY')) >= CAST({{ as_of }} AS DATE) THEN '31-60' WHEN (CAST({{ due_day }} AS DATE) + NUMTODSINTERVAL(90, 'DAY')) >= CAST({{ as_of }} AS DATE) THEN '61-90' ELSE '90+' END

CASE WHEN CAST({{ due_day }} AS DATE) >= CAST({{ as_of }} AS DATE) THEN 'Current' WHEN DATE_ADD(CAST({{ due_day }} AS DATE), INTERVAL 30 DAY) >= CAST({{ as_of }} AS DATE) THEN '1-30' WHEN DATE_ADD(CAST({{ due_day }} AS DATE), INTERVAL 60 DAY) >= CAST({{ as_of }} AS DATE) THEN '31-60' WHEN DATE_ADD(CAST({{ due_day }} AS DATE), INTERVAL 90 DAY) >= CAST({{ as_of }} AS DATE) THEN '61-90' ELSE '90+' END

DATEADD(month, {{ term_months }}, CAST({{ start_day }} AS DATE))

DATE_ADD(CAST({{ start_day }} AS DATE), INTERVAL {{ term_months }} MONTH)

DATEADD(month, {{ term_months }}, CAST({{ start_day }} AS DATE))

(CAST({{ start_day }} AS DATE) + ({{ term_months }}) * INTERVAL '1 month')

(CAST({{ start_day }} AS DATE) + ({{ term_months }}) * INTERVAL '1 month')

DATEADD(month, {{ term_months }}, CAST({{ start_day }} AS DATE))

ADD_MONTHS(CAST({{ start_day }} AS DATE), {{ term_months }})

DATE_ADD(CAST({{ start_day }} AS DATE), INTERVAL {{ term_months }} MONTH)

(DATEADD(day, -30, (DATEADD(month, ({{ term_months }}), CAST(({{ start_day }}) AS DATE)))) <= CAST({{ as_of }} AS DATE) AND (DATEADD(month, ({{ term_months }}), CAST(({{ start_day }}) AS DATE))) >= CAST({{ as_of }} AS DATE))

(DATE_ADD((DATE_ADD(CAST(({{ start_day }}) AS DATE), INTERVAL ({{ term_months }}) MONTH)), INTERVAL -30 DAY) <= CAST({{ as_of }} AS DATE) AND (DATE_ADD(CAST(({{ start_day }}) AS DATE), INTERVAL ({{ term_months }}) MONTH)) >= CAST({{ as_of }} AS DATE))

(DATEADD(day, -30, (DATEADD(month, ({{ term_months }}), CAST(({{ start_day }}) AS DATE)))) <= CAST({{ as_of }} AS DATE) AND (DATEADD(month, ({{ term_months }}), CAST(({{ start_day }}) AS DATE))) >= CAST({{ as_of }} AS DATE))

((((CAST(({{ start_day }}) AS DATE) + (({{ term_months }})) * INTERVAL '1 month')) + (-30) * INTERVAL '1 day') <= CAST({{ as_of }} AS DATE) AND ((CAST(({{ start_day }}) AS DATE) + (({{ term_months }})) * INTERVAL '1 month')) >= CAST({{ as_of }} AS DATE))

((((CAST(({{ start_day }}) AS DATE) + (({{ term_months }})) * INTERVAL '1 month')) + (-30) * INTERVAL '1 day') <= CAST({{ as_of }} AS DATE) AND ((CAST(({{ start_day }}) AS DATE) + (({{ term_months }})) * INTERVAL '1 month')) >= CAST({{ as_of }} AS DATE))

(DATEADD(day, -30, (DATEADD(month, ({{ term_months }}), CAST(({{ start_day }}) AS DATE)))) <= CAST({{ as_of }} AS DATE) AND (DATEADD(month, ({{ term_months }}), CAST(({{ start_day }}) AS DATE))) >= CAST({{ as_of }} AS DATE))

(((ADD_MONTHS(CAST(({{ start_day }}) AS DATE), ({{ term_months }}))) + NUMTODSINTERVAL(-30, 'DAY')) <= CAST({{ as_of }} AS DATE) AND (ADD_MONTHS(CAST(({{ start_day }}) AS DATE), ({{ term_months }}))) >= CAST({{ as_of }} AS DATE))

(DATE_ADD((DATE_ADD(CAST(({{ start_day }}) AS DATE), INTERVAL ({{ term_months }}) MONTH)), INTERVAL -30 DAY) <= CAST({{ as_of }} AS DATE) AND (DATE_ADD(CAST(({{ start_day }}) AS DATE), INTERVAL ({{ term_months }}) MONTH)) >= CAST({{ as_of }} AS DATE))

CASE WHEN EXTRACT(MONTH FROM {{ day }}) >= 7 THEN CASE WHEN EXTRACT(MONTH FROM {{ day }}) <= 9 THEN 'FQ1' ELSE 'FQ2' END WHEN EXTRACT(MONTH FROM {{ day }}) <= 3 THEN 'FQ3' ELSE 'FQ4' END

CASE WHEN EXTRACT(MONTH FROM {{ day }}) >= 7 THEN CASE WHEN EXTRACT(MONTH FROM {{ day }}) <= 9 THEN 'FQ1' ELSE 'FQ2' END WHEN EXTRACT(MONTH FROM {{ day }}) <= 3 THEN 'FQ3' ELSE 'FQ4' END

CASE WHEN EXTRACT(MONTH FROM {{ day }}) >= 7 THEN CASE WHEN EXTRACT(MONTH FROM {{ day }}) <= 9 THEN 'FQ1' ELSE 'FQ2' END WHEN EXTRACT(MONTH FROM {{ day }}) <= 3 THEN 'FQ3' ELSE 'FQ4' END

CASE WHEN EXTRACT(MONTH FROM {{ day }}) >= 7 THEN CASE WHEN EXTRACT(MONTH FROM {{ day }}) <= 9 THEN 'FQ1' ELSE 'FQ2' END WHEN EXTRACT(MONTH FROM {{ day }}) <= 3 THEN 'FQ3' ELSE 'FQ4' END

CASE WHEN EXTRACT(MONTH FROM {{ day }}) >= 7 THEN CASE WHEN EXTRACT(MONTH FROM {{ day }}) <= 9 THEN 'FQ1' ELSE 'FQ2' END WHEN EXTRACT(MONTH FROM {{ day }}) <= 3 THEN 'FQ3' ELSE 'FQ4' END

CASE WHEN DATEPART(month, {{ day }}) >= 7 THEN CASE WHEN DATEPART(month, {{ day }}) <= 9 THEN 'FQ1' ELSE 'FQ2' END WHEN DATEPART(month, {{ day }}) <= 3 THEN 'FQ3' ELSE 'FQ4' END

CASE WHEN EXTRACT(MONTH FROM {{ day }}) >= 7 THEN CASE WHEN EXTRACT(MONTH FROM {{ day }}) <= 9 THEN 'FQ1' ELSE 'FQ2' END WHEN EXTRACT(MONTH FROM {{ day }}) <= 3 THEN 'FQ3' ELSE 'FQ4' END

CASE WHEN EXTRACT(MONTH FROM {{ day }}) >= 7 THEN CASE WHEN EXTRACT(MONTH FROM {{ day }}) <= 9 THEN 'FQ1' ELSE 'FQ2' END WHEN EXTRACT(MONTH FROM {{ day }}) <= 3 THEN 'FQ3' ELSE 'FQ4' END

(DATEADD(day, 1 - EXTRACT(DAY FROM ({{ first_order_day }})), ({{ first_order_day }})))

(DATE_ADD(({{ first_order_day }}), INTERVAL 1 - EXTRACT(DAY FROM ({{ first_order_day }})) DAY))

(DATEADD(day, 1 - EXTRACT(DAY FROM ({{ first_order_day }})), ({{ first_order_day }})))

((({{ first_order_day }}) + (1 - EXTRACT(DAY FROM ({{ first_order_day }}))) * INTERVAL '1 day'))

((({{ first_order_day }}) + (1 - EXTRACT(DAY FROM ({{ first_order_day }}))) * INTERVAL '1 day'))

(DATEADD(day, 1 - DATEPART(day, ({{ first_order_day }})), ({{ first_order_day }})))

((({{ first_order_day }}) + NUMTODSINTERVAL(1 - EXTRACT(DAY FROM ({{ first_order_day }})), 'DAY')))

(DATE_ADD(({{ first_order_day }}), INTERVAL 1 - EXTRACT(DAY FROM ({{ first_order_day }})) DAY))

CASE WHEN {{ employees }} >= 1000 THEN 40 WHEN {{ employees }} >= 100 THEN 25 ELSE 10 END + CASE WHEN (LOWER({{ title }}) LIKE 'vp%' ESCAPE '!' OR LOWER({{ title }}) LIKE 'chief%' ESCAPE '!' OR LOWER({{ title }}) LIKE 'head%' ESCAPE '!') THEN 30 ELSE 10 END + CASE WHEN LOWER(LOWER({{ source }})) IN (LOWER('referral'), LOWER('event')) THEN 20 ELSE 5 END

CASE WHEN {{ employees }} >= 1000 THEN 40 WHEN {{ employees }} >= 100 THEN 25 ELSE 10 END + CASE WHEN (LOWER({{ title }}) LIKE 'vp%' OR LOWER({{ title }}) LIKE 'chief%' OR LOWER({{ title }}) LIKE 'head%') THEN 30 ELSE 10 END + CASE WHEN LOWER(LOWER({{ source }})) IN (LOWER('referral'), LOWER('event')) THEN 20 ELSE 5 END

CASE WHEN {{ employees }} >= 1000 THEN 40 WHEN {{ employees }} >= 100 THEN 25 ELSE 10 END + CASE WHEN (LOWER({{ title }}) LIKE 'vp%' ESCAPE '!' OR LOWER({{ title }}) LIKE 'chief%' ESCAPE '!' OR LOWER({{ title }}) LIKE 'head%' ESCAPE '!') THEN 30 ELSE 10 END + CASE WHEN LOWER(LOWER({{ source }})) IN (LOWER('referral'), LOWER('event')) THEN 20 ELSE 5 END

CASE WHEN {{ employees }} >= 1000 THEN 40 WHEN {{ employees }} >= 100 THEN 25 ELSE 10 END + CASE WHEN (LOWER({{ title }}) LIKE 'vp%' ESCAPE '!' OR LOWER({{ title }}) LIKE 'chief%' ESCAPE '!' OR LOWER({{ title }}) LIKE 'head%' ESCAPE '!') THEN 30 ELSE 10 END + CASE WHEN LOWER(LOWER({{ source }})) IN (LOWER('referral'), LOWER('event')) THEN 20 ELSE 5 END

CASE WHEN {{ employees }} >= 1000 THEN 40 WHEN {{ employees }} >= 100 THEN 25 ELSE 10 END + CASE WHEN (LOWER({{ title }}) LIKE 'vp%' ESCAPE '!' OR LOWER({{ title }}) LIKE 'chief%' ESCAPE '!' OR LOWER({{ title }}) LIKE 'head%' ESCAPE '!') THEN 30 ELSE 10 END + CASE WHEN LOWER(LOWER({{ source }})) IN (LOWER('referral'), LOWER('event')) THEN 20 ELSE 5 END

CASE WHEN {{ employees }} >= 1000 THEN 40 WHEN {{ employees }} >= 100 THEN 25 ELSE 10 END + CASE WHEN (LOWER({{ title }}) LIKE 'vp%' ESCAPE '!' OR LOWER({{ title }}) LIKE 'chief%' ESCAPE '!' OR LOWER({{ title }}) LIKE 'head%' ESCAPE '!') THEN 30 ELSE 10 END + CASE WHEN LOWER(LOWER({{ source }})) IN (LOWER('referral'), LOWER('event')) THEN 20 ELSE 5 END

CASE WHEN {{ employees }} >= 1000 THEN 40 WHEN {{ employees }} >= 100 THEN 25 ELSE 10 END + CASE WHEN (LOWER({{ title }}) LIKE 'vp%' ESCAPE '!' OR LOWER({{ title }}) LIKE 'chief%' ESCAPE '!' OR LOWER({{ title }}) LIKE 'head%' ESCAPE '!') THEN 30 ELSE 10 END + CASE WHEN LOWER(LOWER({{ source }})) IN (LOWER('referral'), LOWER('event')) THEN 20 ELSE 5 END

CASE WHEN {{ employees }} >= 1000 THEN 40 WHEN {{ employees }} >= 100 THEN 25 ELSE 10 END + CASE WHEN (LOWER({{ title }}) LIKE 'vp%' ESCAPE '!' OR LOWER({{ title }}) LIKE 'chief%' ESCAPE '!' OR LOWER({{ title }}) LIKE 'head%' ESCAPE '!') THEN 30 ELSE 10 END + CASE WHEN LOWER(LOWER({{ source }})) IN (LOWER('referral'), LOWER('event')) THEN 20 ELSE 5 END

CASE WHEN {{ score }} >= 80 THEN 'A' WHEN {{ score }} >= 60 THEN 'B' WHEN {{ score }} >= 40 THEN 'C' ELSE 'D' END

CASE WHEN {{ score }} >= 80 THEN 'A' WHEN {{ score }} >= 60 THEN 'B' WHEN {{ score }} >= 40 THEN 'C' ELSE 'D' END

CASE WHEN {{ score }} >= 80 THEN 'A' WHEN {{ score }} >= 60 THEN 'B' WHEN {{ score }} >= 40 THEN 'C' ELSE 'D' END

CASE WHEN {{ score }} >= 80 THEN 'A' WHEN {{ score }} >= 60 THEN 'B' WHEN {{ score }} >= 40 THEN 'C' ELSE 'D' END

CASE WHEN {{ score }} >= 80 THEN 'A' WHEN {{ score }} >= 60 THEN 'B' WHEN {{ score }} >= 40 THEN 'C' ELSE 'D' END

CASE WHEN {{ score }} >= 80 THEN 'A' WHEN {{ score }} >= 60 THEN 'B' WHEN {{ score }} >= 40 THEN 'C' ELSE 'D' END

CASE WHEN {{ score }} >= 80 THEN 'A' WHEN {{ score }} >= 60 THEN 'B' WHEN {{ score }} >= 40 THEN 'C' ELSE 'D' END

CASE WHEN {{ score }} >= 80 THEN 'A' WHEN {{ score }} >= 60 THEN 'B' WHEN {{ score }} >= 40 THEN 'C' ELSE 'D' END

CASE WHEN ({{ days_since_order }} > 180 OR {{ nps }} <= 6) THEN 'High' WHEN ({{ days_since_order }} > 90 OR {{ tickets_open }} >= 2) THEN 'Medium' ELSE 'Low' END

CASE WHEN ({{ days_since_order }} > 180 OR {{ nps }} <= 6) THEN 'High' WHEN ({{ days_since_order }} > 90 OR {{ tickets_open }} >= 2) THEN 'Medium' ELSE 'Low' END

CASE WHEN ({{ days_since_order }} > 180 OR {{ nps }} <= 6) THEN 'High' WHEN ({{ days_since_order }} > 90 OR {{ tickets_open }} >= 2) THEN 'Medium' ELSE 'Low' END

CASE WHEN ({{ days_since_order }} > 180 OR {{ nps }} <= 6) THEN 'High' WHEN ({{ days_since_order }} > 90 OR {{ tickets_open }} >= 2) THEN 'Medium' ELSE 'Low' END

CASE WHEN ({{ days_since_order }} > 180 OR {{ nps }} <= 6) THEN 'High' WHEN ({{ days_since_order }} > 90 OR {{ tickets_open }} >= 2) THEN 'Medium' ELSE 'Low' END

CASE WHEN ({{ days_since_order }} > 180 OR {{ nps }} <= 6) THEN 'High' WHEN ({{ days_since_order }} > 90 OR {{ tickets_open }} >= 2) THEN 'Medium' ELSE 'Low' END

CASE WHEN ({{ days_since_order }} > 180 OR {{ nps }} <= 6) THEN 'High' WHEN ({{ days_since_order }} > 90 OR {{ tickets_open }} >= 2) THEN 'Medium' ELSE 'Low' END

CASE WHEN ({{ days_since_order }} > 180 OR {{ nps }} <= 6) THEN 'High' WHEN ({{ days_since_order }} > 90 OR {{ tickets_open }} >= 2) THEN 'Medium' ELSE 'Low' END

CASE WHEN {{ on_hand }} <= 0 THEN CASE WHEN {{ on_order }} > 0 THEN 'Backordered' ELSE 'Out of stock' END WHEN {{ on_hand }} + {{ on_order }} <= {{ reorder_point }} THEN 'Reorder' ELSE 'In stock' END

CASE WHEN {{ on_hand }} <= 0 THEN CASE WHEN {{ on_order }} > 0 THEN 'Backordered' ELSE 'Out of stock' END WHEN {{ on_hand }} + {{ on_order }} <= {{ reorder_point }} THEN 'Reorder' ELSE 'In stock' END

CASE WHEN {{ on_hand }} <= 0 THEN CASE WHEN {{ on_order }} > 0 THEN 'Backordered' ELSE 'Out of stock' END WHEN {{ on_hand }} + {{ on_order }} <= {{ reorder_point }} THEN 'Reorder' ELSE 'In stock' END

CASE WHEN {{ on_hand }} <= 0 THEN CASE WHEN {{ on_order }} > 0 THEN 'Backordered' ELSE 'Out of stock' END WHEN {{ on_hand }} + {{ on_order }} <= {{ reorder_point }} THEN 'Reorder' ELSE 'In stock' END

CASE WHEN {{ on_hand }} <= 0 THEN CASE WHEN {{ on_order }} > 0 THEN 'Backordered' ELSE 'Out of stock' END WHEN {{ on_hand }} + {{ on_order }} <= {{ reorder_point }} THEN 'Reorder' ELSE 'In stock' END

CASE WHEN {{ on_hand }} <= 0 THEN CASE WHEN {{ on_order }} > 0 THEN 'Backordered' ELSE 'Out of stock' END WHEN {{ on_hand }} + {{ on_order }} <= {{ reorder_point }} THEN 'Reorder' ELSE 'In stock' END

CASE WHEN {{ on_hand }} <= 0 THEN CASE WHEN {{ on_order }} > 0 THEN 'Backordered' ELSE 'Out of stock' END WHEN {{ on_hand }} + {{ on_order }} <= {{ reorder_point }} THEN 'Reorder' ELSE 'In stock' END

CASE WHEN {{ on_hand }} <= 0 THEN CASE WHEN {{ on_order }} > 0 THEN 'Backordered' ELSE 'Out of stock' END WHEN {{ on_hand }} + {{ on_order }} <= {{ reorder_point }} THEN 'Reorder' ELSE 'In stock' END

CASE WHEN {{ on_hand }} + {{ on_order }} >= {{ daily_units }} * ({{ lead_days }} + {{ safety_days }}) THEN 0 ELSE ROUND({{ daily_units }} * ({{ lead_days }} + {{ safety_days }}) - {{ on_hand }} - {{ on_order }}, 0) END

CASE WHEN {{ on_hand }} + {{ on_order }} >= {{ daily_units }} * ({{ lead_days }} + {{ safety_days }}) THEN 0 ELSE ROUND({{ daily_units }} * ({{ lead_days }} + {{ safety_days }}) - {{ on_hand }} - {{ on_order }}, 0) END

CASE WHEN {{ on_hand }} + {{ on_order }} >= {{ daily_units }} * ({{ lead_days }} + {{ safety_days }}) THEN 0 ELSE ROUND({{ daily_units }} * ({{ lead_days }} + {{ safety_days }}) - {{ on_hand }} - {{ on_order }}, 0) END

CASE WHEN {{ on_hand }} + {{ on_order }} >= {{ daily_units }} * ({{ lead_days }} + {{ safety_days }}) THEN 0 ELSE ROUND({{ daily_units }} * ({{ lead_days }} + {{ safety_days }}) - {{ on_hand }} - {{ on_order }}, 0) END

CASE WHEN {{ on_hand }} + {{ on_order }} >= {{ daily_units }} * ({{ lead_days }} + {{ safety_days }}) THEN 0 ELSE ROUND(CAST({{ daily_units }} * ({{ lead_days }} + {{ safety_days }}) - {{ on_hand }} - {{ on_order }} AS NUMERIC), 0) END

CASE WHEN {{ on_hand }} + {{ on_order }} >= {{ daily_units }} * ({{ lead_days }} + {{ safety_days }}) THEN 0 ELSE ROUND({{ daily_units }} * ({{ lead_days }} + {{ safety_days }}) - {{ on_hand }} - {{ on_order }}, 0) END

CASE WHEN {{ on_hand }} + {{ on_order }} >= {{ daily_units }} * ({{ lead_days }} + {{ safety_days }}) THEN 0 ELSE ROUND({{ daily_units }} * ({{ lead_days }} + {{ safety_days }}) - {{ on_hand }} - {{ on_order }}, 0) END

CASE WHEN {{ on_hand }} + {{ on_order }} >= {{ daily_units }} * ({{ lead_days }} + {{ safety_days }}) THEN 0 ELSE ROUND({{ daily_units }} * ({{ lead_days }} + {{ safety_days }}) - {{ on_hand }} - {{ on_order }}, 0) END

CASE WHEN {{ weekly_units }} <= 0 THEN 99 ELSE ROUND({{ on_hand }} / {{ weekly_units }}, 1) END

CASE WHEN {{ weekly_units }} <= 0 THEN 99 ELSE ROUND(CAST({{ on_hand }} AS BIGNUMERIC) / {{ weekly_units }}, 1) END

CASE WHEN {{ weekly_units }} <= 0 THEN 99 ELSE ROUND(CAST({{ on_hand }} AS DECIMAL(38, 10)) / {{ weekly_units }}, 1) END

CASE WHEN {{ weekly_units }} <= 0 THEN 99 ELSE ROUND(CAST({{ on_hand }} AS DECIMAL(38, 10)) / {{ weekly_units }}, 1) END

CASE WHEN {{ weekly_units }} <= 0 THEN 99 ELSE ROUND(CAST(CAST({{ on_hand }} AS NUMERIC) / {{ weekly_units }} AS NUMERIC), 1) END

CASE WHEN {{ weekly_units }} <= 0 THEN 99 ELSE ROUND(CAST({{ on_hand }} AS DECIMAL(38, 10)) / {{ weekly_units }}, 1) END

CASE WHEN {{ weekly_units }} <= 0 THEN 99 ELSE ROUND({{ on_hand }} / {{ weekly_units }}, 1) END

CASE WHEN {{ weekly_units }} <= 0 THEN 99 ELSE ROUND({{ on_hand }} / {{ weekly_units }}, 1) END

CASE WHEN {{ price }} * (1 - {{ promo_pct }} / 100) < {{ floor_price }} THEN {{ floor_price }} ELSE ROUND({{ price }} * (1 - {{ promo_pct }} / 100), 2) END

CASE WHEN {{ price }} * (1 - CAST({{ promo_pct }} AS BIGNUMERIC) / 100) < {{ floor_price }} THEN {{ floor_price }} ELSE ROUND({{ price }} * (1 - CAST({{ promo_pct }} AS BIGNUMERIC) / 100), 2) END

CASE WHEN {{ price }} * (1 - CAST({{ promo_pct }} AS DECIMAL(38, 10)) / 100) < {{ floor_price }} THEN {{ floor_price }} ELSE ROUND({{ price }} * (1 - CAST({{ promo_pct }} AS DECIMAL(38, 10)) / 100), 2) END

CASE WHEN {{ price }} * (1 - CAST({{ promo_pct }} AS DECIMAL(38, 10)) / 100) < {{ floor_price }} THEN {{ floor_price }} ELSE ROUND({{ price }} * (1 - CAST({{ promo_pct }} AS DECIMAL(38, 10)) / 100), 2) END

CASE WHEN {{ price }} * (1 - CAST({{ promo_pct }} AS NUMERIC) / 100) < {{ floor_price }} THEN {{ floor_price }} ELSE ROUND(CAST({{ price }} * (1 - CAST({{ promo_pct }} AS NUMERIC) / 100) AS NUMERIC), 2) END

CASE WHEN {{ price }} * (1 - CAST({{ promo_pct }} AS DECIMAL(38, 10)) / 100) < {{ floor_price }} THEN {{ floor_price }} ELSE ROUND({{ price }} * (1 - CAST({{ promo_pct }} AS DECIMAL(38, 10)) / 100), 2) END

CASE WHEN {{ price }} * (1 - {{ promo_pct }} / 100) < {{ floor_price }} THEN {{ floor_price }} ELSE ROUND({{ price }} * (1 - {{ promo_pct }} / 100), 2) END

CASE WHEN {{ price }} * (1 - {{ promo_pct }} / 100) < {{ floor_price }} THEN {{ floor_price }} ELSE ROUND({{ price }} * (1 - {{ promo_pct }} / 100), 2) END

ROUND(({{ first_price }} + {{ second_price }} + {{ third_price }}) * (1 - {{ bundle_pct }} / 100), 2)

ROUND(({{ first_price }} + {{ second_price }} + {{ third_price }}) * (1 - CAST({{ bundle_pct }} AS BIGNUMERIC) / 100), 2)

ROUND(({{ first_price }} + {{ second_price }} + {{ third_price }}) * (1 - CAST({{ bundle_pct }} AS DECIMAL(38, 10)) / 100), 2)

ROUND(({{ first_price }} + {{ second_price }} + {{ third_price }}) * (1 - CAST({{ bundle_pct }} AS DECIMAL(38, 10)) / 100), 2)

ROUND(CAST(({{ first_price }} + {{ second_price }} + {{ third_price }}) * (1 - CAST({{ bundle_pct }} AS NUMERIC) / 100) AS NUMERIC), 2)

ROUND(({{ first_price }} + {{ second_price }} + {{ third_price }}) * (1 - CAST({{ bundle_pct }} AS DECIMAL(38, 10)) / 100), 2)

ROUND(({{ first_price }} + {{ second_price }} + {{ third_price }}) * (1 - {{ bundle_pct }} / 100), 2)

ROUND(({{ first_price }} + {{ second_price }} + {{ third_price }}) * (1 - {{ bundle_pct }} / 100), 2)

ROUND(CASE WHEN LOWER({{ billing }}) = 'year' THEN {{ amount }} / 12 WHEN LOWER({{ billing }}) = 'quarter' THEN {{ amount }} / 3 WHEN LOWER({{ billing }}) = 'week' THEN {{ amount }} * 52 / 12 ELSE {{ amount }} END, 2)

ROUND(CASE WHEN LOWER({{ billing }}) = 'year' THEN CAST({{ amount }} AS BIGNUMERIC) / 12 WHEN LOWER({{ billing }}) = 'quarter' THEN CAST({{ amount }} AS BIGNUMERIC) / 3 WHEN LOWER({{ billing }}) = 'week' THEN CAST({{ amount }} * 52 AS BIGNUMERIC) / 12 ELSE {{ amount }} END, 2)

ROUND(CASE WHEN LOWER({{ billing }}) = 'year' THEN CAST({{ amount }} AS DECIMAL(38, 10)) / 12 WHEN LOWER({{ billing }}) = 'quarter' THEN CAST({{ amount }} AS DECIMAL(38, 10)) / 3 WHEN LOWER({{ billing }}) = 'week' THEN CAST({{ amount }} * 52 AS DECIMAL(38, 10)) / 12 ELSE {{ amount }} END, 2)

ROUND(CASE WHEN LOWER({{ billing }}) = 'year' THEN CAST({{ amount }} AS DECIMAL(38, 10)) / 12 WHEN LOWER({{ billing }}) = 'quarter' THEN CAST({{ amount }} AS DECIMAL(38, 10)) / 3 WHEN LOWER({{ billing }}) = 'week' THEN CAST({{ amount }} * 52 AS DECIMAL(38, 10)) / 12 ELSE {{ amount }} END, 2)

ROUND(CAST(CASE WHEN LOWER({{ billing }}) = 'year' THEN CAST({{ amount }} AS NUMERIC) / 12 WHEN LOWER({{ billing }}) = 'quarter' THEN CAST({{ amount }} AS NUMERIC) / 3 WHEN LOWER({{ billing }}) = 'week' THEN CAST({{ amount }} * 52 AS NUMERIC) / 12 ELSE {{ amount }} END AS NUMERIC), 2)

ROUND(CASE WHEN LOWER({{ billing }}) = 'year' THEN CAST({{ amount }} AS DECIMAL(38, 10)) / 12 WHEN LOWER({{ billing }}) = 'quarter' THEN CAST({{ amount }} AS DECIMAL(38, 10)) / 3 WHEN LOWER({{ billing }}) = 'week' THEN CAST({{ amount }} * 52 AS DECIMAL(38, 10)) / 12 ELSE {{ amount }} END, 2)

ROUND(CASE WHEN LOWER({{ billing }}) = 'year' THEN {{ amount }} / 12 WHEN LOWER({{ billing }}) = 'quarter' THEN {{ amount }} / 3 WHEN LOWER({{ billing }}) = 'week' THEN {{ amount }} * 52 / 12 ELSE {{ amount }} END, 2)

ROUND(CASE WHEN LOWER({{ billing }}) = 'year' THEN {{ amount }} / 12 WHEN LOWER({{ billing }}) = 'quarter' THEN {{ amount }} / 3 WHEN LOWER({{ billing }}) = 'week' THEN {{ amount }} * 52 / 12 ELSE {{ amount }} END, 2)

CASE WHEN {{ prev_mrr }} = 0 THEN CASE WHEN {{ mrr }} > 0 THEN 'New' ELSE 'None' END WHEN {{ mrr }} = 0 THEN 'Churned' WHEN {{ mrr }} > {{ prev_mrr }} THEN 'Expansion' WHEN {{ mrr }} < {{ prev_mrr }} THEN 'Contraction' ELSE 'Flat' END

CASE WHEN {{ prev_mrr }} = 0 THEN CASE WHEN {{ mrr }} > 0 THEN 'New' ELSE 'None' END WHEN {{ mrr }} = 0 THEN 'Churned' WHEN {{ mrr }} > {{ prev_mrr }} THEN 'Expansion' WHEN {{ mrr }} < {{ prev_mrr }} THEN 'Contraction' ELSE 'Flat' END

CASE WHEN {{ prev_mrr }} = 0 THEN CASE WHEN {{ mrr }} > 0 THEN 'New' ELSE 'None' END WHEN {{ mrr }} = 0 THEN 'Churned' WHEN {{ mrr }} > {{ prev_mrr }} THEN 'Expansion' WHEN {{ mrr }} < {{ prev_mrr }} THEN 'Contraction' ELSE 'Flat' END

CASE WHEN {{ prev_mrr }} = 0 THEN CASE WHEN {{ mrr }} > 0 THEN 'New' ELSE 'None' END WHEN {{ mrr }} = 0 THEN 'Churned' WHEN {{ mrr }} > {{ prev_mrr }} THEN 'Expansion' WHEN {{ mrr }} < {{ prev_mrr }} THEN 'Contraction' ELSE 'Flat' END

CASE WHEN {{ prev_mrr }} = 0 THEN CASE WHEN {{ mrr }} > 0 THEN 'New' ELSE 'None' END WHEN {{ mrr }} = 0 THEN 'Churned' WHEN {{ mrr }} > {{ prev_mrr }} THEN 'Expansion' WHEN {{ mrr }} < {{ prev_mrr }} THEN 'Contraction' ELSE 'Flat' END

CASE WHEN {{ prev_mrr }} = 0 THEN CASE WHEN {{ mrr }} > 0 THEN 'New' ELSE 'None' END WHEN {{ mrr }} = 0 THEN 'Churned' WHEN {{ mrr }} > {{ prev_mrr }} THEN 'Expansion' WHEN {{ mrr }} < {{ prev_mrr }} THEN 'Contraction' ELSE 'Flat' END

CASE WHEN {{ prev_mrr }} = 0 THEN CASE WHEN {{ mrr }} > 0 THEN 'New' ELSE 'None' END WHEN {{ mrr }} = 0 THEN 'Churned' WHEN {{ mrr }} > {{ prev_mrr }} THEN 'Expansion' WHEN {{ mrr }} < {{ prev_mrr }} THEN 'Contraction' ELSE 'Flat' END

CASE WHEN {{ prev_mrr }} = 0 THEN CASE WHEN {{ mrr }} > 0 THEN 'New' ELSE 'None' END WHEN {{ mrr }} = 0 THEN 'Churned' WHEN {{ mrr }} > {{ prev_mrr }} THEN 'Expansion' WHEN {{ mrr }} < {{ prev_mrr }} THEN 'Contraction' ELSE 'Flat' END

CASE WHEN {{ amount_paid }} >= {{ amount_due }} THEN 'Paid' WHEN {{ amount_paid }} > 0 THEN CASE WHEN CAST({{ due_day }} AS DATE) < CAST({{ as_of }} AS DATE) THEN 'Partial, overdue' ELSE 'Partial' END WHEN CAST({{ due_day }} AS DATE) < CAST({{ as_of }} AS DATE) THEN 'Overdue' ELSE 'Open' END

CASE WHEN {{ amount_paid }} >= {{ amount_due }} THEN 'Paid' WHEN {{ amount_paid }} > 0 THEN CASE WHEN CAST({{ due_day }} AS DATE) < CAST({{ as_of }} AS DATE) THEN 'Partial, overdue' ELSE 'Partial' END WHEN CAST({{ due_day }} AS DATE) < CAST({{ as_of }} AS DATE) THEN 'Overdue' ELSE 'Open' END

CASE WHEN {{ amount_paid }} >= {{ amount_due }} THEN 'Paid' WHEN {{ amount_paid }} > 0 THEN CASE WHEN CAST({{ due_day }} AS DATE) < CAST({{ as_of }} AS DATE) THEN 'Partial, overdue' ELSE 'Partial' END WHEN CAST({{ due_day }} AS DATE) < CAST({{ as_of }} AS DATE) THEN 'Overdue' ELSE 'Open' END

CASE WHEN {{ amount_paid }} >= {{ amount_due }} THEN 'Paid' WHEN {{ amount_paid }} > 0 THEN CASE WHEN CAST({{ due_day }} AS DATE) < CAST({{ as_of }} AS DATE) THEN 'Partial, overdue' ELSE 'Partial' END WHEN CAST({{ due_day }} AS DATE) < CAST({{ as_of }} AS DATE) THEN 'Overdue' ELSE 'Open' END

CASE WHEN {{ amount_paid }} >= {{ amount_due }} THEN 'Paid' WHEN {{ amount_paid }} > 0 THEN CASE WHEN CAST({{ due_day }} AS DATE) < CAST({{ as_of }} AS DATE) THEN 'Partial, overdue' ELSE 'Partial' END WHEN CAST({{ due_day }} AS DATE) < CAST({{ as_of }} AS DATE) THEN 'Overdue' ELSE 'Open' END

CASE WHEN {{ amount_paid }} >= {{ amount_due }} THEN 'Paid' WHEN {{ amount_paid }} > 0 THEN CASE WHEN CAST({{ due_day }} AS DATE) < CAST({{ as_of }} AS DATE) THEN 'Partial, overdue' ELSE 'Partial' END WHEN CAST({{ due_day }} AS DATE) < CAST({{ as_of }} AS DATE) THEN 'Overdue' ELSE 'Open' END

CASE WHEN {{ amount_paid }} >= {{ amount_due }} THEN 'Paid' WHEN {{ amount_paid }} > 0 THEN CASE WHEN CAST({{ due_day }} AS DATE) < CAST({{ as_of }} AS DATE) THEN 'Partial, overdue' ELSE 'Partial' END WHEN CAST({{ due_day }} AS DATE) < CAST({{ as_of }} AS DATE) THEN 'Overdue' ELSE 'Open' END

CASE WHEN {{ amount_paid }} >= {{ amount_due }} THEN 'Paid' WHEN {{ amount_paid }} > 0 THEN CASE WHEN CAST({{ due_day }} AS DATE) < CAST({{ as_of }} AS DATE) THEN 'Partial, overdue' ELSE 'Partial' END WHEN CAST({{ due_day }} AS DATE) < CAST({{ as_of }} AS DATE) THEN 'Overdue' ELSE 'Open' END

DATEADD(day, CASE WHEN LOWER({{ method }}) = 'overnight' THEN 1 WHEN LOWER({{ method }}) = 'two-day' THEN 2 WHEN {{ zone }} >= 7 THEN 7 WHEN {{ zone }} >= 4 THEN 5 ELSE 3 END, {{ ship_day }})

DATE_ADD({{ ship_day }}, INTERVAL CASE WHEN LOWER({{ method }}) = 'overnight' THEN 1 WHEN LOWER({{ method }}) = 'two-day' THEN 2 WHEN {{ zone }} >= 7 THEN 7 WHEN {{ zone }} >= 4 THEN 5 ELSE 3 END DAY)

DATEADD(day, CASE WHEN LOWER({{ method }}) = 'overnight' THEN 1 WHEN LOWER({{ method }}) = 'two-day' THEN 2 WHEN {{ zone }} >= 7 THEN 7 WHEN {{ zone }} >= 4 THEN 5 ELSE 3 END, {{ ship_day }})

({{ ship_day }} + (CASE WHEN LOWER({{ method }}) = 'overnight' THEN 1 WHEN LOWER({{ method }}) = 'two-day' THEN 2 WHEN {{ zone }} >= 7 THEN 7 WHEN {{ zone }} >= 4 THEN 5 ELSE 3 END) * INTERVAL '1 day')

({{ ship_day }} + (CASE WHEN LOWER({{ method }}) = 'overnight' THEN 1 WHEN LOWER({{ method }}) = 'two-day' THEN 2 WHEN {{ zone }} >= 7 THEN 7 WHEN {{ zone }} >= 4 THEN 5 ELSE 3 END) * INTERVAL '1 day')

DATEADD(day, CASE WHEN LOWER({{ method }}) = 'overnight' THEN 1 WHEN LOWER({{ method }}) = 'two-day' THEN 2 WHEN {{ zone }} >= 7 THEN 7 WHEN {{ zone }} >= 4 THEN 5 ELSE 3 END, {{ ship_day }})

({{ ship_day }} + NUMTODSINTERVAL(CASE WHEN LOWER({{ method }}) = 'overnight' THEN 1 WHEN LOWER({{ method }}) = 'two-day' THEN 2 WHEN {{ zone }} >= 7 THEN 7 WHEN {{ zone }} >= 4 THEN 5 ELSE 3 END, 'DAY'))

DATE_ADD({{ ship_day }}, INTERVAL CASE WHEN LOWER({{ method }}) = 'overnight' THEN 1 WHEN LOWER({{ method }}) = 'two-day' THEN 2 WHEN {{ zone }} >= 7 THEN 7 WHEN {{ zone }} >= 4 THEN 5 ELSE 3 END DAY)

DATEADD(day, CASE WHEN {{ priority }} = 'P1' THEN 1 WHEN {{ priority }} = 'P2' THEN 3 ELSE 7 END, CAST({{ opened_day }} AS DATE)) < CAST(COALESCE({{ resolved_day }}, {{ as_of }}) AS DATE)

DATE_ADD(CAST({{ opened_day }} AS DATE), INTERVAL CASE WHEN {{ priority }} = 'P1' THEN 1 WHEN {{ priority }} = 'P2' THEN 3 ELSE 7 END DAY) < CAST(COALESCE({{ resolved_day }}, {{ as_of }}) AS DATE)

DATEADD(day, CASE WHEN {{ priority }} = 'P1' THEN 1 WHEN {{ priority }} = 'P2' THEN 3 ELSE 7 END, CAST({{ opened_day }} AS DATE)) < CAST(COALESCE({{ resolved_day }}, {{ as_of }}) AS DATE)

(CAST({{ opened_day }} AS DATE) + (CASE WHEN {{ priority }} = 'P1' THEN 1 WHEN {{ priority }} = 'P2' THEN 3 ELSE 7 END) * INTERVAL '1 day') < CAST(COALESCE({{ resolved_day }}, {{ as_of }}) AS DATE)

(CAST({{ opened_day }} AS DATE) + (CASE WHEN {{ priority }} = 'P1' THEN 1 WHEN {{ priority }} = 'P2' THEN 3 ELSE 7 END) * INTERVAL '1 day') < CAST(COALESCE({{ resolved_day }}, {{ as_of }}) AS DATE)

DATEADD(day, CASE WHEN {{ priority }} = 'P1' THEN 1 WHEN {{ priority }} = 'P2' THEN 3 ELSE 7 END, CAST({{ opened_day }} AS DATE)) < CAST(COALESCE({{ resolved_day }}, {{ as_of }}) AS DATE)

(CAST({{ opened_day }} AS DATE) + NUMTODSINTERVAL(CASE WHEN {{ priority }} = 'P1' THEN 1 WHEN {{ priority }} = 'P2' THEN 3 ELSE 7 END, 'DAY')) < CAST(COALESCE({{ resolved_day }}, {{ as_of }}) AS DATE)

DATE_ADD(CAST({{ opened_day }} AS DATE), INTERVAL CASE WHEN {{ priority }} = 'P1' THEN 1 WHEN {{ priority }} = 'P2' THEN 3 ELSE 7 END DAY) < CAST(COALESCE({{ resolved_day }}, {{ as_of }}) AS DATE)

CASE WHEN {{ total }} >= 1000 THEN 30 WHEN {{ total }} >= 300 THEN 15 ELSE 0 END + CASE WHEN {{ is_new_customer }} THEN 20 ELSE 0 END + CASE WHEN {{ ship_matches_bill }} THEN 0 ELSE 25 END + CASE WHEN (NOT ((LOWER(TRIM(({{ email }}))) LIKE '%@gmail.com' ESCAPE '!' OR LOWER(TRIM(({{ email }}))) LIKE '%@yahoo.com' ESCAPE '!' OR LOWER(TRIM(({{ email }}))) LIKE '%@outlook.com' ESCAPE '!'))) THEN 0 ELSE 5 END + CASE WHEN UPPER({{ country }}) = 'US' THEN 0 ELSE 20 END

CASE WHEN {{ total }} >= 1000 THEN 30 WHEN {{ total }} >= 300 THEN 15 ELSE 0 END + CASE WHEN {{ is_new_customer }} THEN 20 ELSE 0 END + CASE WHEN {{ ship_matches_bill }} THEN 0 ELSE 25 END + CASE WHEN (NOT ((LOWER(TRIM(({{ email }}))) LIKE '%@gmail.com' OR LOWER(TRIM(({{ email }}))) LIKE '%@yahoo.com' OR LOWER(TRIM(({{ email }}))) LIKE '%@outlook.com'))) THEN 0 ELSE 5 END + CASE WHEN UPPER({{ country }}) = 'US' THEN 0 ELSE 20 END

CASE WHEN {{ total }} >= 1000 THEN 30 WHEN {{ total }} >= 300 THEN 15 ELSE 0 END + CASE WHEN {{ is_new_customer }} THEN 20 ELSE 0 END + CASE WHEN {{ ship_matches_bill }} THEN 0 ELSE 25 END + CASE WHEN (NOT ((LOWER(TRIM(({{ email }}))) LIKE '%@gmail.com' ESCAPE '!' OR LOWER(TRIM(({{ email }}))) LIKE '%@yahoo.com' ESCAPE '!' OR LOWER(TRIM(({{ email }}))) LIKE '%@outlook.com' ESCAPE '!'))) THEN 0 ELSE 5 END + CASE WHEN UPPER({{ country }}) = 'US' THEN 0 ELSE 20 END

CASE WHEN {{ total }} >= 1000 THEN 30 WHEN {{ total }} >= 300 THEN 15 ELSE 0 END + CASE WHEN {{ is_new_customer }} THEN 20 ELSE 0 END + CASE WHEN {{ ship_matches_bill }} THEN 0 ELSE 25 END + CASE WHEN (NOT ((LOWER(TRIM(({{ email }}))) LIKE '%@gmail.com' ESCAPE '!' OR LOWER(TRIM(({{ email }}))) LIKE '%@yahoo.com' ESCAPE '!' OR LOWER(TRIM(({{ email }}))) LIKE '%@outlook.com' ESCAPE '!'))) THEN 0 ELSE 5 END + CASE WHEN UPPER({{ country }}) = 'US' THEN 0 ELSE 20 END

CASE WHEN {{ total }} >= 1000 THEN 30 WHEN {{ total }} >= 300 THEN 15 ELSE 0 END + CASE WHEN {{ is_new_customer }} THEN 20 ELSE 0 END + CASE WHEN {{ ship_matches_bill }} THEN 0 ELSE 25 END + CASE WHEN (NOT ((LOWER(TRIM(({{ email }}))) LIKE '%@gmail.com' ESCAPE '!' OR LOWER(TRIM(({{ email }}))) LIKE '%@yahoo.com' ESCAPE '!' OR LOWER(TRIM(({{ email }}))) LIKE '%@outlook.com' ESCAPE '!'))) THEN 0 ELSE 5 END + CASE WHEN UPPER({{ country }}) = 'US' THEN 0 ELSE 20 END

CASE WHEN {{ total }} >= 1000 THEN 30 WHEN {{ total }} >= 300 THEN 15 ELSE 0 END + CASE WHEN {{ is_new_customer }} THEN 20 ELSE 0 END + CASE WHEN {{ ship_matches_bill }} THEN 0 ELSE 25 END + CASE WHEN (NOT ((LOWER(TRIM(({{ email }}))) LIKE '%@gmail.com' ESCAPE '!' OR LOWER(TRIM(({{ email }}))) LIKE '%@yahoo.com' ESCAPE '!' OR LOWER(TRIM(({{ email }}))) LIKE '%@outlook.com' ESCAPE '!'))) THEN 0 ELSE 5 END + CASE WHEN UPPER({{ country }}) = 'US' THEN 0 ELSE 20 END

CASE WHEN {{ total }} >= 1000 THEN 30 WHEN {{ total }} >= 300 THEN 15 ELSE 0 END + CASE WHEN {{ is_new_customer }} THEN 20 ELSE 0 END + CASE WHEN {{ ship_matches_bill }} THEN 0 ELSE 25 END + CASE WHEN (NOT ((LOWER(TRIM(({{ email }}))) LIKE '%@gmail.com' ESCAPE '!' OR LOWER(TRIM(({{ email }}))) LIKE '%@yahoo.com' ESCAPE '!' OR LOWER(TRIM(({{ email }}))) LIKE '%@outlook.com' ESCAPE '!'))) THEN 0 ELSE 5 END + CASE WHEN UPPER({{ country }}) = 'US' THEN 0 ELSE 20 END

CASE WHEN {{ total }} >= 1000 THEN 30 WHEN {{ total }} >= 300 THEN 15 ELSE 0 END + CASE WHEN {{ is_new_customer }} THEN 20 ELSE 0 END + CASE WHEN {{ ship_matches_bill }} THEN 0 ELSE 25 END + CASE WHEN (NOT ((LOWER(TRIM(({{ email }}))) LIKE '%@gmail.com' ESCAPE '!' OR LOWER(TRIM(({{ email }}))) LIKE '%@yahoo.com' ESCAPE '!' OR LOWER(TRIM(({{ email }}))) LIKE '%@outlook.com' ESCAPE '!'))) THEN 0 ELSE 5 END + CASE WHEN UPPER({{ country }}) = 'US' THEN 0 ELSE 20 END

CASE WHEN {{ score }} >= 60 THEN 'Hold for review' WHEN {{ score }} >= 35 THEN 'Verify by email' ELSE 'Approve' END

CASE WHEN {{ score }} >= 60 THEN 'Hold for review' WHEN {{ score }} >= 35 THEN 'Verify by email' ELSE 'Approve' END

CASE WHEN {{ score }} >= 60 THEN 'Hold for review' WHEN {{ score }} >= 35 THEN 'Verify by email' ELSE 'Approve' END

CASE WHEN {{ score }} >= 60 THEN 'Hold for review' WHEN {{ score }} >= 35 THEN 'Verify by email' ELSE 'Approve' END

CASE WHEN {{ score }} >= 60 THEN 'Hold for review' WHEN {{ score }} >= 35 THEN 'Verify by email' ELSE 'Approve' END

CASE WHEN {{ score }} >= 60 THEN 'Hold for review' WHEN {{ score }} >= 35 THEN 'Verify by email' ELSE 'Approve' END

CASE WHEN {{ score }} >= 60 THEN 'Hold for review' WHEN {{ score }} >= 35 THEN 'Verify by email' ELSE 'Approve' END

CASE WHEN {{ score }} >= 60 THEN 'Hold for review' WHEN {{ score }} >= 35 THEN 'Verify by email' ELSE 'Approve' END

(CASE WHEN ((CASE WHEN ({{ total }}) >= 1000 THEN 30 WHEN ({{ total }}) >= 300 THEN 15 ELSE 0 END + CASE WHEN ({{ is_new_customer }}) THEN 20 ELSE 0 END + CASE WHEN ({{ ship_matches_bill }}) THEN 0 ELSE 25 END + CASE WHEN (NOT ((LOWER(TRIM((({{ email }})))) LIKE '%@gmail.com' ESCAPE '!' OR LOWER(TRIM((({{ email }})))) LIKE '%@yahoo.com' ESCAPE '!' OR LOWER(TRIM((({{ email }})))) LIKE '%@outlook.com' ESCAPE '!'))) THEN 0 ELSE 5 END + CASE WHEN UPPER(({{ country }})) = 'US' THEN 0 ELSE 20 END)) >= 60 THEN 'Hold for review' WHEN ((CASE WHEN ({{ total }}) >= 1000 THEN 30 WHEN ({{ total }}) >= 300 THEN 15 ELSE 0 END + CASE WHEN ({{ is_new_customer }}) THEN 20 ELSE 0 END + CASE WHEN ({{ ship_matches_bill }}) THEN 0 ELSE 25 END + CASE WHEN (NOT ((LOWER(TRIM((({{ email }})))) LIKE '%@gmail.com' ESCAPE '!' OR LOWER(TRIM((({{ email }})))) LIKE '%@yahoo.com' ESCAPE '!' OR LOWER(TRIM((({{ email }})))) LIKE '%@outlook.com' ESCAPE '!'))) THEN 0 ELSE 5 END + CASE WHEN UPPER(({{ country }})) = 'US' THEN 0 ELSE 20 END)) >= 35 THEN 'Verify by email' ELSE 'Approve' END)

(CASE WHEN ((CASE WHEN ({{ total }}) >= 1000 THEN 30 WHEN ({{ total }}) >= 300 THEN 15 ELSE 0 END + CASE WHEN ({{ is_new_customer }}) THEN 20 ELSE 0 END + CASE WHEN ({{ ship_matches_bill }}) THEN 0 ELSE 25 END + CASE WHEN (NOT ((LOWER(TRIM((({{ email }})))) LIKE '%@gmail.com' OR LOWER(TRIM((({{ email }})))) LIKE '%@yahoo.com' OR LOWER(TRIM((({{ email }})))) LIKE '%@outlook.com'))) THEN 0 ELSE 5 END + CASE WHEN UPPER(({{ country }})) = 'US' THEN 0 ELSE 20 END)) >= 60 THEN 'Hold for review' WHEN ((CASE WHEN ({{ total }}) >= 1000 THEN 30 WHEN ({{ total }}) >= 300 THEN 15 ELSE 0 END + CASE WHEN ({{ is_new_customer }}) THEN 20 ELSE 0 END + CASE WHEN ({{ ship_matches_bill }}) THEN 0 ELSE 25 END + CASE WHEN (NOT ((LOWER(TRIM((({{ email }})))) LIKE '%@gmail.com' OR LOWER(TRIM((({{ email }})))) LIKE '%@yahoo.com' OR LOWER(TRIM((({{ email }})))) LIKE '%@outlook.com'))) THEN 0 ELSE 5 END + CASE WHEN UPPER(({{ country }})) = 'US' THEN 0 ELSE 20 END)) >= 35 THEN 'Verify by email' ELSE 'Approve' END)

(CASE WHEN ((CASE WHEN ({{ total }}) >= 1000 THEN 30 WHEN ({{ total }}) >= 300 THEN 15 ELSE 0 END + CASE WHEN ({{ is_new_customer }}) THEN 20 ELSE 0 END + CASE WHEN ({{ ship_matches_bill }}) THEN 0 ELSE 25 END + CASE WHEN (NOT ((LOWER(TRIM((({{ email }})))) LIKE '%@gmail.com' ESCAPE '!' OR LOWER(TRIM((({{ email }})))) LIKE '%@yahoo.com' ESCAPE '!' OR LOWER(TRIM((({{ email }})))) LIKE '%@outlook.com' ESCAPE '!'))) THEN 0 ELSE 5 END + CASE WHEN UPPER(({{ country }})) = 'US' THEN 0 ELSE 20 END)) >= 60 THEN 'Hold for review' WHEN ((CASE WHEN ({{ total }}) >= 1000 THEN 30 WHEN ({{ total }}) >= 300 THEN 15 ELSE 0 END + CASE WHEN ({{ is_new_customer }}) THEN 20 ELSE 0 END + CASE WHEN ({{ ship_matches_bill }}) THEN 0 ELSE 25 END + CASE WHEN (NOT ((LOWER(TRIM((({{ email }})))) LIKE '%@gmail.com' ESCAPE '!' OR LOWER(TRIM((({{ email }})))) LIKE '%@yahoo.com' ESCAPE '!' OR LOWER(TRIM((({{ email }})))) LIKE '%@outlook.com' ESCAPE '!'))) THEN 0 ELSE 5 END + CASE WHEN UPPER(({{ country }})) = 'US' THEN 0 ELSE 20 END)) >= 35 THEN 'Verify by email' ELSE 'Approve' END)

(CASE WHEN ((CASE WHEN ({{ total }}) >= 1000 THEN 30 WHEN ({{ total }}) >= 300 THEN 15 ELSE 0 END + CASE WHEN ({{ is_new_customer }}) THEN 20 ELSE 0 END + CASE WHEN ({{ ship_matches_bill }}) THEN 0 ELSE 25 END + CASE WHEN (NOT ((LOWER(TRIM((({{ email }})))) LIKE '%@gmail.com' ESCAPE '!' OR LOWER(TRIM((({{ email }})))) LIKE '%@yahoo.com' ESCAPE '!' OR LOWER(TRIM((({{ email }})))) LIKE '%@outlook.com' ESCAPE '!'))) THEN 0 ELSE 5 END + CASE WHEN UPPER(({{ country }})) = 'US' THEN 0 ELSE 20 END)) >= 60 THEN 'Hold for review' WHEN ((CASE WHEN ({{ total }}) >= 1000 THEN 30 WHEN ({{ total }}) >= 300 THEN 15 ELSE 0 END + CASE WHEN ({{ is_new_customer }}) THEN 20 ELSE 0 END + CASE WHEN ({{ ship_matches_bill }}) THEN 0 ELSE 25 END + CASE WHEN (NOT ((LOWER(TRIM((({{ email }})))) LIKE '%@gmail.com' ESCAPE '!' OR LOWER(TRIM((({{ email }})))) LIKE '%@yahoo.com' ESCAPE '!' OR LOWER(TRIM((({{ email }})))) LIKE '%@outlook.com' ESCAPE '!'))) THEN 0 ELSE 5 END + CASE WHEN UPPER(({{ country }})) = 'US' THEN 0 ELSE 20 END)) >= 35 THEN 'Verify by email' ELSE 'Approve' END)

(CASE WHEN ((CASE WHEN ({{ total }}) >= 1000 THEN 30 WHEN ({{ total }}) >= 300 THEN 15 ELSE 0 END + CASE WHEN ({{ is_new_customer }}) THEN 20 ELSE 0 END + CASE WHEN ({{ ship_matches_bill }}) THEN 0 ELSE 25 END + CASE WHEN (NOT ((LOWER(TRIM((({{ email }})))) LIKE '%@gmail.com' ESCAPE '!' OR LOWER(TRIM((({{ email }})))) LIKE '%@yahoo.com' ESCAPE '!' OR LOWER(TRIM((({{ email }})))) LIKE '%@outlook.com' ESCAPE '!'))) THEN 0 ELSE 5 END + CASE WHEN UPPER(({{ country }})) = 'US' THEN 0 ELSE 20 END)) >= 60 THEN 'Hold for review' WHEN ((CASE WHEN ({{ total }}) >= 1000 THEN 30 WHEN ({{ total }}) >= 300 THEN 15 ELSE 0 END + CASE WHEN ({{ is_new_customer }}) THEN 20 ELSE 0 END + CASE WHEN ({{ ship_matches_bill }}) THEN 0 ELSE 25 END + CASE WHEN (NOT ((LOWER(TRIM((({{ email }})))) LIKE '%@gmail.com' ESCAPE '!' OR LOWER(TRIM((({{ email }})))) LIKE '%@yahoo.com' ESCAPE '!' OR LOWER(TRIM((({{ email }})))) LIKE '%@outlook.com' ESCAPE '!'))) THEN 0 ELSE 5 END + CASE WHEN UPPER(({{ country }})) = 'US' THEN 0 ELSE 20 END)) >= 35 THEN 'Verify by email' ELSE 'Approve' END)

(CASE WHEN ((CASE WHEN ({{ total }}) >= 1000 THEN 30 WHEN ({{ total }}) >= 300 THEN 15 ELSE 0 END + CASE WHEN ({{ is_new_customer }}) THEN 20 ELSE 0 END + CASE WHEN ({{ ship_matches_bill }}) THEN 0 ELSE 25 END + CASE WHEN (NOT ((LOWER(TRIM((({{ email }})))) LIKE '%@gmail.com' ESCAPE '!' OR LOWER(TRIM((({{ email }})))) LIKE '%@yahoo.com' ESCAPE '!' OR LOWER(TRIM((({{ email }})))) LIKE '%@outlook.com' ESCAPE '!'))) THEN 0 ELSE 5 END + CASE WHEN UPPER(({{ country }})) = 'US' THEN 0 ELSE 20 END)) >= 60 THEN 'Hold for review' WHEN ((CASE WHEN ({{ total }}) >= 1000 THEN 30 WHEN ({{ total }}) >= 300 THEN 15 ELSE 0 END + CASE WHEN ({{ is_new_customer }}) THEN 20 ELSE 0 END + CASE WHEN ({{ ship_matches_bill }}) THEN 0 ELSE 25 END + CASE WHEN (NOT ((LOWER(TRIM((({{ email }})))) LIKE '%@gmail.com' ESCAPE '!' OR LOWER(TRIM((({{ email }})))) LIKE '%@yahoo.com' ESCAPE '!' OR LOWER(TRIM((({{ email }})))) LIKE '%@outlook.com' ESCAPE '!'))) THEN 0 ELSE 5 END + CASE WHEN UPPER(({{ country }})) = 'US' THEN 0 ELSE 20 END)) >= 35 THEN 'Verify by email' ELSE 'Approve' END)

(CASE WHEN ((CASE WHEN ({{ total }}) >= 1000 THEN 30 WHEN ({{ total }}) >= 300 THEN 15 ELSE 0 END + CASE WHEN ({{ is_new_customer }}) THEN 20 ELSE 0 END + CASE WHEN ({{ ship_matches_bill }}) THEN 0 ELSE 25 END + CASE WHEN (NOT ((LOWER(TRIM((({{ email }})))) LIKE '%@gmail.com' ESCAPE '!' OR LOWER(TRIM((({{ email }})))) LIKE '%@yahoo.com' ESCAPE '!' OR LOWER(TRIM((({{ email }})))) LIKE '%@outlook.com' ESCAPE '!'))) THEN 0 ELSE 5 END + CASE WHEN UPPER(({{ country }})) = 'US' THEN 0 ELSE 20 END)) >= 60 THEN 'Hold for review' WHEN ((CASE WHEN ({{ total }}) >= 1000 THEN 30 WHEN ({{ total }}) >= 300 THEN 15 ELSE 0 END + CASE WHEN ({{ is_new_customer }}) THEN 20 ELSE 0 END + CASE WHEN ({{ ship_matches_bill }}) THEN 0 ELSE 25 END + CASE WHEN (NOT ((LOWER(TRIM((({{ email }})))) LIKE '%@gmail.com' ESCAPE '!' OR LOWER(TRIM((({{ email }})))) LIKE '%@yahoo.com' ESCAPE '!' OR LOWER(TRIM((({{ email }})))) LIKE '%@outlook.com' ESCAPE '!'))) THEN 0 ELSE 5 END + CASE WHEN UPPER(({{ country }})) = 'US' THEN 0 ELSE 20 END)) >= 35 THEN 'Verify by email' ELSE 'Approve' END)

(CASE WHEN ((CASE WHEN ({{ total }}) >= 1000 THEN 30 WHEN ({{ total }}) >= 300 THEN 15 ELSE 0 END + CASE WHEN ({{ is_new_customer }}) THEN 20 ELSE 0 END + CASE WHEN ({{ ship_matches_bill }}) THEN 0 ELSE 25 END + CASE WHEN (NOT ((LOWER(TRIM((({{ email }})))) LIKE '%@gmail.com' ESCAPE '!' OR LOWER(TRIM((({{ email }})))) LIKE '%@yahoo.com' ESCAPE '!' OR LOWER(TRIM((({{ email }})))) LIKE '%@outlook.com' ESCAPE '!'))) THEN 0 ELSE 5 END + CASE WHEN UPPER(({{ country }})) = 'US' THEN 0 ELSE 20 END)) >= 60 THEN 'Hold for review' WHEN ((CASE WHEN ({{ total }}) >= 1000 THEN 30 WHEN ({{ total }}) >= 300 THEN 15 ELSE 0 END + CASE WHEN ({{ is_new_customer }}) THEN 20 ELSE 0 END + CASE WHEN ({{ ship_matches_bill }}) THEN 0 ELSE 25 END + CASE WHEN (NOT ((LOWER(TRIM((({{ email }})))) LIKE '%@gmail.com' ESCAPE '!' OR LOWER(TRIM((({{ email }})))) LIKE '%@yahoo.com' ESCAPE '!' OR LOWER(TRIM((({{ email }})))) LIKE '%@outlook.com' ESCAPE '!'))) THEN 0 ELSE 5 END + CASE WHEN UPPER(({{ country }})) = 'US' THEN 0 ELSE 20 END)) >= 35 THEN 'Verify by email' ELSE 'Approve' END)

CASE WHEN NOT (({{ email }} IS NULL)) THEN CONCAT('e:', COALESCE(CAST((LOWER(TRIM(({{ email }})))) AS VARCHAR), '')) WHEN NOT (({{ phone }} IS NULL)) THEN CONCAT('p:', COALESCE(CAST((REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM(({{ phone }})), '(', ''), ')', ''), '-', ''), ' ', ''), '.', '')) AS VARCHAR), '')) ELSE CONCAT('n:', COALESCE(CAST(LOWER(TRIM({{ first }})) AS VARCHAR), ''), '|', COALESCE(CAST(LOWER(TRIM({{ last }})) AS VARCHAR), ''), '|', COALESCE(CAST((LEFT(TRIM(({{ zip }})), 5)) AS VARCHAR), '')) END

CASE WHEN NOT (({{ email }} IS NULL)) THEN CONCAT('e:', COALESCE(CAST((LOWER(TRIM(({{ email }})))) AS STRING), '')) WHEN NOT (({{ phone }} IS NULL)) THEN CONCAT('p:', COALESCE(CAST((REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM(({{ phone }})), '(', ''), ')', ''), '-', ''), ' ', ''), '.', '')) AS STRING), '')) ELSE CONCAT('n:', COALESCE(CAST(LOWER(TRIM({{ first }})) AS STRING), ''), '|', COALESCE(CAST(LOWER(TRIM({{ last }})) AS STRING), ''), '|', COALESCE(CAST((LEFT(TRIM(({{ zip }})), 5)) AS STRING), '')) END

CASE WHEN NOT (({{ email }} IS NULL)) THEN CONCAT('e:', COALESCE(CAST((LOWER(TRIM(({{ email }})))) AS STRING), '')) WHEN NOT (({{ phone }} IS NULL)) THEN CONCAT('p:', COALESCE(CAST((REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM(({{ phone }})), '(', ''), ')', ''), '-', ''), ' ', ''), '.', '')) AS STRING), '')) ELSE CONCAT('n:', COALESCE(CAST(LOWER(TRIM({{ first }})) AS STRING), ''), '|', COALESCE(CAST(LOWER(TRIM({{ last }})) AS STRING), ''), '|', COALESCE(CAST((LEFT(TRIM(({{ zip }})), 5)) AS STRING), '')) END

CASE WHEN NOT (({{ email }} IS NULL)) THEN ('e:' || COALESCE(CAST((LOWER(TRIM(({{ email }})))) AS VARCHAR), '')) WHEN NOT (({{ phone }} IS NULL)) THEN ('p:' || COALESCE(CAST((REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM(({{ phone }})), '(', ''), ')', ''), '-', ''), ' ', ''), '.', '')) AS VARCHAR), '')) ELSE ('n:' || COALESCE(CAST(LOWER(TRIM({{ first }})) AS VARCHAR), '') || '|' || COALESCE(CAST(LOWER(TRIM({{ last }})) AS VARCHAR), '') || '|' || COALESCE(CAST((LEFT(TRIM(({{ zip }})), 5)) AS VARCHAR), '')) END

CASE WHEN NOT (({{ email }} IS NULL)) THEN CONCAT('e:', (LOWER(TRIM(({{ email }}))))) WHEN NOT (({{ phone }} IS NULL)) THEN CONCAT('p:', (REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM(({{ phone }})), '(', ''), ')', ''), '-', ''), ' ', ''), '.', ''))) ELSE CONCAT('n:', LOWER(TRIM({{ first }})), '|', LOWER(TRIM({{ last }})), '|', (LEFT(TRIM(({{ zip }})), 5))) END

CASE WHEN NOT (({{ email }} IS NULL)) THEN CONCAT('e:', (LOWER(TRIM(({{ email }}))))) WHEN NOT (({{ phone }} IS NULL)) THEN CONCAT('p:', (REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM(({{ phone }})), '(', ''), ')', ''), '-', ''), ' ', ''), '.', ''))) ELSE CONCAT('n:', LOWER(TRIM({{ first }})), '|', LOWER(TRIM({{ last }})), '|', (LEFT(TRIM(({{ zip }})), 5))) END

CASE WHEN NOT (({{ email }} IS NULL)) THEN ('e:' || (LOWER(TRIM(({{ email }}))))) WHEN NOT (({{ phone }} IS NULL)) THEN ('p:' || (REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM(({{ phone }})), '(', ''), ')', ''), '-', ''), ' ', ''), '.', ''))) ELSE ('n:' || LOWER(TRIM({{ first }})) || '|' || LOWER(TRIM({{ last }})) || '|' || (SUBSTR(TRIM(({{ zip }})), 1, 5))) END

CASE WHEN NOT (({{ email }} IS NULL)) THEN CONCAT('e:', COALESCE(CAST((LOWER(TRIM(({{ email }})))) AS CHAR), '')) WHEN NOT (({{ phone }} IS NULL)) THEN CONCAT('p:', COALESCE(CAST((REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(TRIM(({{ phone }})), '(', ''), ')', ''), '-', ''), ' ', ''), '.', '')) AS CHAR), '')) ELSE CONCAT('n:', COALESCE(CAST(LOWER(TRIM({{ first }})) AS CHAR), ''), '|', COALESCE(CAST(LOWER(TRIM({{ last }})) AS CHAR), ''), '|', COALESCE(CAST((LEFT(TRIM(({{ zip }})), 5)) AS CHAR), '')) END

CONCAT(COALESCE(CAST(TRIM({{ street }}) AS VARCHAR), ''), ', ', COALESCE(CAST(TRIM({{ city }}) AS VARCHAR), ''), ', ', COALESCE(CAST((UPPER(LEFT(TRIM(({{ state }})), 2))) AS VARCHAR), ''), ' ', COALESCE(CAST((LEFT(TRIM(({{ zip }})), 5)) AS VARCHAR), ''))

CONCAT(COALESCE(CAST(TRIM({{ street }}) AS STRING), ''), ', ', COALESCE(CAST(TRIM({{ city }}) AS STRING), ''), ', ', COALESCE(CAST((UPPER(LEFT(TRIM(({{ state }})), 2))) AS STRING), ''), ' ', COALESCE(CAST((LEFT(TRIM(({{ zip }})), 5)) AS STRING), ''))

CONCAT(COALESCE(CAST(TRIM({{ street }}) AS STRING), ''), ', ', COALESCE(CAST(TRIM({{ city }}) AS STRING), ''), ', ', COALESCE(CAST((UPPER(LEFT(TRIM(({{ state }})), 2))) AS STRING), ''), ' ', COALESCE(CAST((LEFT(TRIM(({{ zip }})), 5)) AS STRING), ''))

(COALESCE(CAST(TRIM({{ street }}) AS VARCHAR), '') || ', ' || COALESCE(CAST(TRIM({{ city }}) AS VARCHAR), '') || ', ' || COALESCE(CAST((UPPER(LEFT(TRIM(({{ state }})), 2))) AS VARCHAR), '') || ' ' || COALESCE(CAST((LEFT(TRIM(({{ zip }})), 5)) AS VARCHAR), ''))

CONCAT(TRIM({{ street }}), ', ', TRIM({{ city }}), ', ', (UPPER(LEFT(TRIM(({{ state }})), 2))), ' ', (LEFT(TRIM(({{ zip }})), 5)))

CONCAT(TRIM({{ street }}), ', ', TRIM({{ city }}), ', ', (UPPER(LEFT(TRIM(({{ state }})), 2))), ' ', (LEFT(TRIM(({{ zip }})), 5)))

(TRIM({{ street }}) || ', ' || TRIM({{ city }}) || ', ' || (UPPER(SUBSTR(TRIM(({{ state }})), 1, 2))) || ' ' || (SUBSTR(TRIM(({{ zip }})), 1, 5)))

CONCAT(COALESCE(CAST(TRIM({{ street }}) AS CHAR), ''), ', ', COALESCE(CAST(TRIM({{ city }}) AS CHAR), ''), ', ', COALESCE(CAST((UPPER(LEFT(TRIM(({{ state }})), 2))) AS CHAR), ''), ' ', COALESCE(CAST((LEFT(TRIM(({{ zip }})), 5)) AS CHAR), ''))

ROUND((ROUND(({{ subtotal }}) * (1 - ({{ discount_pct }}) / 100), 2)) + (ROUND(((ROUND(({{ subtotal }}) * (1 - ({{ discount_pct }}) / 100), 2))) * CASE WHEN UPPER(({{ state }})) = 'CA' THEN 0.0725 WHEN UPPER(({{ state }})) = 'TX' THEN 0.0625 WHEN UPPER(({{ state }})) = 'NY' THEN 0.04 WHEN LOWER(UPPER(({{ state }}))) IN (LOWER('OR'), LOWER('MT'), LOWER('NH'), LOWER('DE')) THEN 0 ELSE 0.05 END, 2)) + {{ shipping }}, 2)

ROUND((ROUND(({{ subtotal }}) * (1 - CAST(({{ discount_pct }}) AS BIGNUMERIC) / 100), 2)) + (ROUND(((ROUND(({{ subtotal }}) * (1 - CAST(({{ discount_pct }}) AS BIGNUMERIC) / 100), 2))) * CASE WHEN UPPER(({{ state }})) = 'CA' THEN BIGNUMERIC '0.0725' WHEN UPPER(({{ state }})) = 'TX' THEN BIGNUMERIC '0.0625' WHEN UPPER(({{ state }})) = 'NY' THEN BIGNUMERIC '0.04' WHEN LOWER(UPPER(({{ state }}))) IN (LOWER('OR'), LOWER('MT'), LOWER('NH'), LOWER('DE')) THEN 0 ELSE BIGNUMERIC '0.05' END, 2)) + {{ shipping }}, 2)

ROUND((ROUND(({{ subtotal }}) * (1 - CAST(({{ discount_pct }}) AS DECIMAL(38, 10)) / 100), 2)) + (ROUND(((ROUND(({{ subtotal }}) * (1 - CAST(({{ discount_pct }}) AS DECIMAL(38, 10)) / 100), 2))) * CASE WHEN UPPER(({{ state }})) = 'CA' THEN 0.0725 WHEN UPPER(({{ state }})) = 'TX' THEN 0.0625 WHEN UPPER(({{ state }})) = 'NY' THEN 0.04 WHEN LOWER(UPPER(({{ state }}))) IN (LOWER('OR'), LOWER('MT'), LOWER('NH'), LOWER('DE')) THEN 0 ELSE 0.05 END, 2)) + {{ shipping }}, 2)

ROUND((ROUND(({{ subtotal }}) * (1 - CAST(({{ discount_pct }}) AS DECIMAL(38, 10)) / 100), 2)) + (ROUND(((ROUND(({{ subtotal }}) * (1 - CAST(({{ discount_pct }}) AS DECIMAL(38, 10)) / 100), 2))) * CASE WHEN UPPER(({{ state }})) = 'CA' THEN 0.0725 WHEN UPPER(({{ state }})) = 'TX' THEN 0.0625 WHEN UPPER(({{ state }})) = 'NY' THEN 0.04 WHEN LOWER(UPPER(({{ state }}))) IN (LOWER('OR'), LOWER('MT'), LOWER('NH'), LOWER('DE')) THEN 0 ELSE 0.05 END, 2)) + {{ shipping }}, 2)

ROUND(CAST((ROUND(CAST(({{ subtotal }}) * (1 - CAST(({{ discount_pct }}) AS NUMERIC) / 100) AS NUMERIC), 2)) + (ROUND(CAST(((ROUND(CAST(({{ subtotal }}) * (1 - CAST(({{ discount_pct }}) AS NUMERIC) / 100) AS NUMERIC), 2))) * CASE WHEN UPPER(({{ state }})) = 'CA' THEN 0.0725 WHEN UPPER(({{ state }})) = 'TX' THEN 0.0625 WHEN UPPER(({{ state }})) = 'NY' THEN 0.04 WHEN LOWER(UPPER(({{ state }}))) IN (LOWER('OR'), LOWER('MT'), LOWER('NH'), LOWER('DE')) THEN 0 ELSE 0.05 END AS NUMERIC), 2)) + {{ shipping }} AS NUMERIC), 2)

ROUND((ROUND(({{ subtotal }}) * (1 - CAST(({{ discount_pct }}) AS DECIMAL(38, 10)) / 100), 2)) + (ROUND(((ROUND(({{ subtotal }}) * (1 - CAST(({{ discount_pct }}) AS DECIMAL(38, 10)) / 100), 2))) * CASE WHEN UPPER(({{ state }})) = 'CA' THEN 0.0725 WHEN UPPER(({{ state }})) = 'TX' THEN 0.0625 WHEN UPPER(({{ state }})) = 'NY' THEN 0.04 WHEN LOWER(UPPER(({{ state }}))) IN (LOWER('OR'), LOWER('MT'), LOWER('NH'), LOWER('DE')) THEN 0 ELSE 0.05 END, 2)) + {{ shipping }}, 2)

ROUND((ROUND(({{ subtotal }}) * (1 - ({{ discount_pct }}) / 100), 2)) + (ROUND(((ROUND(({{ subtotal }}) * (1 - ({{ discount_pct }}) / 100), 2))) * CASE WHEN UPPER(({{ state }})) = 'CA' THEN 0.0725 WHEN UPPER(({{ state }})) = 'TX' THEN 0.0625 WHEN UPPER(({{ state }})) = 'NY' THEN 0.04 WHEN LOWER(UPPER(({{ state }}))) IN (LOWER('OR'), LOWER('MT'), LOWER('NH'), LOWER('DE')) THEN 0 ELSE 0.05 END, 2)) + {{ shipping }}, 2)

ROUND((ROUND(({{ subtotal }}) * (1 - ({{ discount_pct }}) / 100), 2)) + (ROUND(((ROUND(({{ subtotal }}) * (1 - ({{ discount_pct }}) / 100), 2))) * CASE WHEN UPPER(({{ state }})) = 'CA' THEN 0.0725 WHEN UPPER(({{ state }})) = 'TX' THEN 0.0625 WHEN UPPER(({{ state }})) = 'NY' THEN 0.04 WHEN LOWER(UPPER(({{ state }}))) IN (LOWER('OR'), LOWER('MT'), LOWER('NH'), LOWER('DE')) THEN 0 ELSE 0.05 END, 2)) + {{ shipping }}, 2)

ROUND((ROUND(CASE WHEN ({{ sales }}) <= 10000 THEN ({{ sales }}) * 0.05 WHEN ({{ sales }}) <= 50000 THEN 500 + (({{ sales }}) - 10000) * 0.07 ELSE 3300 + (({{ sales }}) - 50000) * 0.1 END, 2)) * CASE WHEN {{ sales }} >= {{ quota }} THEN 1.25 ELSE 1 END + CASE WHEN {{ is_new_logo }} THEN 250 ELSE 0 END, 2)

ROUND((ROUND(CASE WHEN ({{ sales }}) <= 10000 THEN ({{ sales }}) * BIGNUMERIC '0.05' WHEN ({{ sales }}) <= 50000 THEN 500 + (({{ sales }}) - 10000) * BIGNUMERIC '0.07' ELSE 3300 + (({{ sales }}) - 50000) * BIGNUMERIC '0.1' END, 2)) * CASE WHEN {{ sales }} >= {{ quota }} THEN BIGNUMERIC '1.25' ELSE 1 END + CASE WHEN {{ is_new_logo }} THEN 250 ELSE 0 END, 2)

ROUND((ROUND(CASE WHEN ({{ sales }}) <= 10000 THEN ({{ sales }}) * 0.05 WHEN ({{ sales }}) <= 50000 THEN 500 + (({{ sales }}) - 10000) * 0.07 ELSE 3300 + (({{ sales }}) - 50000) * 0.1 END, 2)) * CASE WHEN {{ sales }} >= {{ quota }} THEN 1.25 ELSE 1 END + CASE WHEN {{ is_new_logo }} THEN 250 ELSE 0 END, 2)

ROUND((ROUND(CASE WHEN ({{ sales }}) <= 10000 THEN ({{ sales }}) * 0.05 WHEN ({{ sales }}) <= 50000 THEN 500 + (({{ sales }}) - 10000) * 0.07 ELSE 3300 + (({{ sales }}) - 50000) * 0.1 END, 2)) * CASE WHEN {{ sales }} >= {{ quota }} THEN 1.25 ELSE 1 END + CASE WHEN {{ is_new_logo }} THEN 250 ELSE 0 END, 2)

ROUND(CAST((ROUND(CAST(CASE WHEN ({{ sales }}) <= 10000 THEN ({{ sales }}) * 0.05 WHEN ({{ sales }}) <= 50000 THEN 500 + (({{ sales }}) - 10000) * 0.07 ELSE 3300 + (({{ sales }}) - 50000) * 0.1 END AS NUMERIC), 2)) * CASE WHEN {{ sales }} >= {{ quota }} THEN 1.25 ELSE 1 END + CASE WHEN {{ is_new_logo }} THEN 250 ELSE 0 END AS NUMERIC), 2)

ROUND((ROUND(CASE WHEN ({{ sales }}) <= 10000 THEN ({{ sales }}) * 0.05 WHEN ({{ sales }}) <= 50000 THEN 500 + (({{ sales }}) - 10000) * 0.07 ELSE 3300 + (({{ sales }}) - 50000) * 0.1 END, 2)) * CASE WHEN {{ sales }} >= {{ quota }} THEN 1.25 ELSE 1 END + CASE WHEN {{ is_new_logo }} THEN 250 ELSE 0 END, 2)

ROUND((ROUND(CASE WHEN ({{ sales }}) <= 10000 THEN ({{ sales }}) * 0.05 WHEN ({{ sales }}) <= 50000 THEN 500 + (({{ sales }}) - 10000) * 0.07 ELSE 3300 + (({{ sales }}) - 50000) * 0.1 END, 2)) * CASE WHEN {{ sales }} >= {{ quota }} THEN 1.25 ELSE 1 END + CASE WHEN {{ is_new_logo }} THEN 250 ELSE 0 END, 2)

ROUND((ROUND(CASE WHEN ({{ sales }}) <= 10000 THEN ({{ sales }}) * 0.05 WHEN ({{ sales }}) <= 50000 THEN 500 + (({{ sales }}) - 10000) * 0.07 ELSE 3300 + (({{ sales }}) - 50000) * 0.1 END, 2)) * CASE WHEN {{ sales }} >= {{ quota }} THEN 1.25 ELSE 1 END + CASE WHEN {{ is_new_logo }} THEN 250 ELSE 0 END, 2)

ROUND({{ distance_mi }} * {{ weight_lb }} / 2000 * CASE WHEN LOWER({{ mode }}) = 'air' THEN 0.6 WHEN LOWER({{ mode }}) = 'truck' THEN 0.16 WHEN LOWER({{ mode }}) = 'rail' THEN 0.03 ELSE 0.02 END, 2)

ROUND(CAST({{ distance_mi }} * {{ weight_lb }} AS BIGNUMERIC) / 2000 * CASE WHEN LOWER({{ mode }}) = 'air' THEN BIGNUMERIC '0.6' WHEN LOWER({{ mode }}) = 'truck' THEN BIGNUMERIC '0.16' WHEN LOWER({{ mode }}) = 'rail' THEN BIGNUMERIC '0.03' ELSE BIGNUMERIC '0.02' END, 2)

ROUND(CAST({{ distance_mi }} * {{ weight_lb }} AS DECIMAL(38, 10)) / 2000 * CASE WHEN LOWER({{ mode }}) = 'air' THEN 0.6 WHEN LOWER({{ mode }}) = 'truck' THEN 0.16 WHEN LOWER({{ mode }}) = 'rail' THEN 0.03 ELSE 0.02 END, 2)

ROUND(CAST({{ distance_mi }} * {{ weight_lb }} AS DECIMAL(38, 10)) / 2000 * CASE WHEN LOWER({{ mode }}) = 'air' THEN 0.6 WHEN LOWER({{ mode }}) = 'truck' THEN 0.16 WHEN LOWER({{ mode }}) = 'rail' THEN 0.03 ELSE 0.02 END, 2)

ROUND(CAST(CAST({{ distance_mi }} * {{ weight_lb }} AS NUMERIC) / 2000 * CASE WHEN LOWER({{ mode }}) = 'air' THEN 0.6 WHEN LOWER({{ mode }}) = 'truck' THEN 0.16 WHEN LOWER({{ mode }}) = 'rail' THEN 0.03 ELSE 0.02 END AS NUMERIC), 2)

ROUND(CAST({{ distance_mi }} * {{ weight_lb }} AS DECIMAL(38, 10)) / 2000 * CASE WHEN LOWER({{ mode }}) = 'air' THEN 0.6 WHEN LOWER({{ mode }}) = 'truck' THEN 0.16 WHEN LOWER({{ mode }}) = 'rail' THEN 0.03 ELSE 0.02 END, 2)

ROUND({{ distance_mi }} * {{ weight_lb }} / 2000 * CASE WHEN LOWER({{ mode }}) = 'air' THEN 0.6 WHEN LOWER({{ mode }}) = 'truck' THEN 0.16 WHEN LOWER({{ mode }}) = 'rail' THEN 0.03 ELSE 0.02 END, 2)

ROUND({{ distance_mi }} * {{ weight_lb }} / 2000 * CASE WHEN LOWER({{ mode }}) = 'air' THEN 0.6 WHEN LOWER({{ mode }}) = 'truck' THEN 0.16 WHEN LOWER({{ mode }}) = 'rail' THEN 0.03 ELSE 0.02 END, 2)

CASE WHEN {{ amount_paid }} >= {{ amount_due }} THEN 'None' WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN DATEADD(day, 30, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN DATEADD(day, 60, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN DATEADD(day, 90, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = 'Current' THEN 'None' WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN DATEADD(day, 30, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN DATEADD(day, 60, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN DATEADD(day, 90, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = '1-30' THEN 'Reminder' WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN DATEADD(day, 30, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN DATEADD(day, 60, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN DATEADD(day, 90, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = '31-60' THEN 'Second notice' WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN DATEADD(day, 30, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN DATEADD(day, 60, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN DATEADD(day, 90, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = '61-90' THEN 'Final notice' ELSE 'Collections' END

CASE WHEN {{ amount_paid }} >= {{ amount_due }} THEN 'None' WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN DATE_ADD(CAST(({{ due_day }}) AS DATE), INTERVAL 30 DAY) >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN DATE_ADD(CAST(({{ due_day }}) AS DATE), INTERVAL 60 DAY) >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN DATE_ADD(CAST(({{ due_day }}) AS DATE), INTERVAL 90 DAY) >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = 'Current' THEN 'None' WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN DATE_ADD(CAST(({{ due_day }}) AS DATE), INTERVAL 30 DAY) >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN DATE_ADD(CAST(({{ due_day }}) AS DATE), INTERVAL 60 DAY) >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN DATE_ADD(CAST(({{ due_day }}) AS DATE), INTERVAL 90 DAY) >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = '1-30' THEN 'Reminder' WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN DATE_ADD(CAST(({{ due_day }}) AS DATE), INTERVAL 30 DAY) >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN DATE_ADD(CAST(({{ due_day }}) AS DATE), INTERVAL 60 DAY) >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN DATE_ADD(CAST(({{ due_day }}) AS DATE), INTERVAL 90 DAY) >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = '31-60' THEN 'Second notice' WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN DATE_ADD(CAST(({{ due_day }}) AS DATE), INTERVAL 30 DAY) >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN DATE_ADD(CAST(({{ due_day }}) AS DATE), INTERVAL 60 DAY) >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN DATE_ADD(CAST(({{ due_day }}) AS DATE), INTERVAL 90 DAY) >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = '61-90' THEN 'Final notice' ELSE 'Collections' END

CASE WHEN {{ amount_paid }} >= {{ amount_due }} THEN 'None' WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN DATEADD(day, 30, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN DATEADD(day, 60, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN DATEADD(day, 90, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = 'Current' THEN 'None' WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN DATEADD(day, 30, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN DATEADD(day, 60, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN DATEADD(day, 90, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = '1-30' THEN 'Reminder' WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN DATEADD(day, 30, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN DATEADD(day, 60, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN DATEADD(day, 90, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = '31-60' THEN 'Second notice' WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN DATEADD(day, 30, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN DATEADD(day, 60, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN DATEADD(day, 90, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = '61-90' THEN 'Final notice' ELSE 'Collections' END

CASE WHEN {{ amount_paid }} >= {{ amount_due }} THEN 'None' WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN (CAST(({{ due_day }}) AS DATE) + (30) * INTERVAL '1 day') >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN (CAST(({{ due_day }}) AS DATE) + (60) * INTERVAL '1 day') >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN (CAST(({{ due_day }}) AS DATE) + (90) * INTERVAL '1 day') >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = 'Current' THEN 'None' WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN (CAST(({{ due_day }}) AS DATE) + (30) * INTERVAL '1 day') >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN (CAST(({{ due_day }}) AS DATE) + (60) * INTERVAL '1 day') >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN (CAST(({{ due_day }}) AS DATE) + (90) * INTERVAL '1 day') >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = '1-30' THEN 'Reminder' WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN (CAST(({{ due_day }}) AS DATE) + (30) * INTERVAL '1 day') >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN (CAST(({{ due_day }}) AS DATE) + (60) * INTERVAL '1 day') >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN (CAST(({{ due_day }}) AS DATE) + (90) * INTERVAL '1 day') >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = '31-60' THEN 'Second notice' WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN (CAST(({{ due_day }}) AS DATE) + (30) * INTERVAL '1 day') >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN (CAST(({{ due_day }}) AS DATE) + (60) * INTERVAL '1 day') >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN (CAST(({{ due_day }}) AS DATE) + (90) * INTERVAL '1 day') >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = '61-90' THEN 'Final notice' ELSE 'Collections' END

CASE WHEN {{ amount_paid }} >= {{ amount_due }} THEN 'None' WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN (CAST(({{ due_day }}) AS DATE) + (30) * INTERVAL '1 day') >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN (CAST(({{ due_day }}) AS DATE) + (60) * INTERVAL '1 day') >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN (CAST(({{ due_day }}) AS DATE) + (90) * INTERVAL '1 day') >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = 'Current' THEN 'None' WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN (CAST(({{ due_day }}) AS DATE) + (30) * INTERVAL '1 day') >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN (CAST(({{ due_day }}) AS DATE) + (60) * INTERVAL '1 day') >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN (CAST(({{ due_day }}) AS DATE) + (90) * INTERVAL '1 day') >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = '1-30' THEN 'Reminder' WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN (CAST(({{ due_day }}) AS DATE) + (30) * INTERVAL '1 day') >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN (CAST(({{ due_day }}) AS DATE) + (60) * INTERVAL '1 day') >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN (CAST(({{ due_day }}) AS DATE) + (90) * INTERVAL '1 day') >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = '31-60' THEN 'Second notice' WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN (CAST(({{ due_day }}) AS DATE) + (30) * INTERVAL '1 day') >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN (CAST(({{ due_day }}) AS DATE) + (60) * INTERVAL '1 day') >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN (CAST(({{ due_day }}) AS DATE) + (90) * INTERVAL '1 day') >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = '61-90' THEN 'Final notice' ELSE 'Collections' END

CASE WHEN {{ amount_paid }} >= {{ amount_due }} THEN 'None' WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN DATEADD(day, 30, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN DATEADD(day, 60, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN DATEADD(day, 90, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = 'Current' THEN 'None' WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN DATEADD(day, 30, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN DATEADD(day, 60, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN DATEADD(day, 90, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = '1-30' THEN 'Reminder' WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN DATEADD(day, 30, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN DATEADD(day, 60, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN DATEADD(day, 90, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = '31-60' THEN 'Second notice' WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN DATEADD(day, 30, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN DATEADD(day, 60, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN DATEADD(day, 90, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = '61-90' THEN 'Final notice' ELSE 'Collections' END

CASE WHEN {{ amount_paid }} >= {{ amount_due }} THEN 'None' WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN (CAST(({{ due_day }}) AS DATE) + NUMTODSINTERVAL(30, 'DAY')) >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN (CAST(({{ due_day }}) AS DATE) + NUMTODSINTERVAL(60, 'DAY')) >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN (CAST(({{ due_day }}) AS DATE) + NUMTODSINTERVAL(90, 'DAY')) >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = 'Current' THEN 'None' WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN (CAST(({{ due_day }}) AS DATE) + NUMTODSINTERVAL(30, 'DAY')) >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN (CAST(({{ due_day }}) AS DATE) + NUMTODSINTERVAL(60, 'DAY')) >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN (CAST(({{ due_day }}) AS DATE) + NUMTODSINTERVAL(90, 'DAY')) >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = '1-30' THEN 'Reminder' WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN (CAST(({{ due_day }}) AS DATE) + NUMTODSINTERVAL(30, 'DAY')) >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN (CAST(({{ due_day }}) AS DATE) + NUMTODSINTERVAL(60, 'DAY')) >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN (CAST(({{ due_day }}) AS DATE) + NUMTODSINTERVAL(90, 'DAY')) >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = '31-60' THEN 'Second notice' WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN (CAST(({{ due_day }}) AS DATE) + NUMTODSINTERVAL(30, 'DAY')) >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN (CAST(({{ due_day }}) AS DATE) + NUMTODSINTERVAL(60, 'DAY')) >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN (CAST(({{ due_day }}) AS DATE) + NUMTODSINTERVAL(90, 'DAY')) >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = '61-90' THEN 'Final notice' ELSE 'Collections' END

CASE WHEN {{ amount_paid }} >= {{ amount_due }} THEN 'None' WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN DATE_ADD(CAST(({{ due_day }}) AS DATE), INTERVAL 30 DAY) >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN DATE_ADD(CAST(({{ due_day }}) AS DATE), INTERVAL 60 DAY) >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN DATE_ADD(CAST(({{ due_day }}) AS DATE), INTERVAL 90 DAY) >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = 'Current' THEN 'None' WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN DATE_ADD(CAST(({{ due_day }}) AS DATE), INTERVAL 30 DAY) >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN DATE_ADD(CAST(({{ due_day }}) AS DATE), INTERVAL 60 DAY) >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN DATE_ADD(CAST(({{ due_day }}) AS DATE), INTERVAL 90 DAY) >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = '1-30' THEN 'Reminder' WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN DATE_ADD(CAST(({{ due_day }}) AS DATE), INTERVAL 30 DAY) >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN DATE_ADD(CAST(({{ due_day }}) AS DATE), INTERVAL 60 DAY) >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN DATE_ADD(CAST(({{ due_day }}) AS DATE), INTERVAL 90 DAY) >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = '31-60' THEN 'Second notice' WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN DATE_ADD(CAST(({{ due_day }}) AS DATE), INTERVAL 30 DAY) >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN DATE_ADD(CAST(({{ due_day }}) AS DATE), INTERVAL 60 DAY) >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN DATE_ADD(CAST(({{ due_day }}) AS DATE), INTERVAL 90 DAY) >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = '61-90' THEN 'Final notice' ELSE 'Collections' END

CASE WHEN {{ amount_paid }} >= {{ amount_due }} THEN 0 ELSE ROUND(({{ amount_due }} - {{ amount_paid }}) * CASE WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN DATEADD(day, 30, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN DATEADD(day, 60, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN DATEADD(day, 90, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = 'Current' THEN 0 WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN DATEADD(day, 30, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN DATEADD(day, 60, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN DATEADD(day, 90, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = '1-30' THEN 0.015 ELSE 0.03 END, 2) END

CASE WHEN {{ amount_paid }} >= {{ amount_due }} THEN 0 ELSE ROUND(({{ amount_due }} - {{ amount_paid }}) * CASE WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN DATE_ADD(CAST(({{ due_day }}) AS DATE), INTERVAL 30 DAY) >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN DATE_ADD(CAST(({{ due_day }}) AS DATE), INTERVAL 60 DAY) >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN DATE_ADD(CAST(({{ due_day }}) AS DATE), INTERVAL 90 DAY) >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = 'Current' THEN 0 WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN DATE_ADD(CAST(({{ due_day }}) AS DATE), INTERVAL 30 DAY) >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN DATE_ADD(CAST(({{ due_day }}) AS DATE), INTERVAL 60 DAY) >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN DATE_ADD(CAST(({{ due_day }}) AS DATE), INTERVAL 90 DAY) >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = '1-30' THEN BIGNUMERIC '0.015' ELSE BIGNUMERIC '0.03' END, 2) END

CASE WHEN {{ amount_paid }} >= {{ amount_due }} THEN 0 ELSE ROUND(({{ amount_due }} - {{ amount_paid }}) * CASE WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN DATEADD(day, 30, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN DATEADD(day, 60, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN DATEADD(day, 90, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = 'Current' THEN 0 WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN DATEADD(day, 30, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN DATEADD(day, 60, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN DATEADD(day, 90, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = '1-30' THEN 0.015 ELSE 0.03 END, 2) END

CASE WHEN {{ amount_paid }} >= {{ amount_due }} THEN 0 ELSE ROUND(({{ amount_due }} - {{ amount_paid }}) * CASE WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN (CAST(({{ due_day }}) AS DATE) + (30) * INTERVAL '1 day') >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN (CAST(({{ due_day }}) AS DATE) + (60) * INTERVAL '1 day') >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN (CAST(({{ due_day }}) AS DATE) + (90) * INTERVAL '1 day') >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = 'Current' THEN 0 WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN (CAST(({{ due_day }}) AS DATE) + (30) * INTERVAL '1 day') >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN (CAST(({{ due_day }}) AS DATE) + (60) * INTERVAL '1 day') >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN (CAST(({{ due_day }}) AS DATE) + (90) * INTERVAL '1 day') >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = '1-30' THEN 0.015 ELSE 0.03 END, 2) END

CASE WHEN {{ amount_paid }} >= {{ amount_due }} THEN 0 ELSE ROUND(CAST(({{ amount_due }} - {{ amount_paid }}) * CASE WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN (CAST(({{ due_day }}) AS DATE) + (30) * INTERVAL '1 day') >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN (CAST(({{ due_day }}) AS DATE) + (60) * INTERVAL '1 day') >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN (CAST(({{ due_day }}) AS DATE) + (90) * INTERVAL '1 day') >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = 'Current' THEN 0 WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN (CAST(({{ due_day }}) AS DATE) + (30) * INTERVAL '1 day') >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN (CAST(({{ due_day }}) AS DATE) + (60) * INTERVAL '1 day') >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN (CAST(({{ due_day }}) AS DATE) + (90) * INTERVAL '1 day') >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = '1-30' THEN 0.015 ELSE 0.03 END AS NUMERIC), 2) END

CASE WHEN {{ amount_paid }} >= {{ amount_due }} THEN 0 ELSE ROUND(({{ amount_due }} - {{ amount_paid }}) * CASE WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN DATEADD(day, 30, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN DATEADD(day, 60, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN DATEADD(day, 90, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = 'Current' THEN 0 WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN DATEADD(day, 30, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN DATEADD(day, 60, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN DATEADD(day, 90, CAST(({{ due_day }}) AS DATE)) >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = '1-30' THEN 0.015 ELSE 0.03 END, 2) END

CASE WHEN {{ amount_paid }} >= {{ amount_due }} THEN 0 ELSE ROUND(({{ amount_due }} - {{ amount_paid }}) * CASE WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN (CAST(({{ due_day }}) AS DATE) + NUMTODSINTERVAL(30, 'DAY')) >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN (CAST(({{ due_day }}) AS DATE) + NUMTODSINTERVAL(60, 'DAY')) >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN (CAST(({{ due_day }}) AS DATE) + NUMTODSINTERVAL(90, 'DAY')) >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = 'Current' THEN 0 WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN (CAST(({{ due_day }}) AS DATE) + NUMTODSINTERVAL(30, 'DAY')) >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN (CAST(({{ due_day }}) AS DATE) + NUMTODSINTERVAL(60, 'DAY')) >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN (CAST(({{ due_day }}) AS DATE) + NUMTODSINTERVAL(90, 'DAY')) >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = '1-30' THEN 0.015 ELSE 0.03 END, 2) END

CASE WHEN {{ amount_paid }} >= {{ amount_due }} THEN 0 ELSE ROUND(({{ amount_due }} - {{ amount_paid }}) * CASE WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN DATE_ADD(CAST(({{ due_day }}) AS DATE), INTERVAL 30 DAY) >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN DATE_ADD(CAST(({{ due_day }}) AS DATE), INTERVAL 60 DAY) >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN DATE_ADD(CAST(({{ due_day }}) AS DATE), INTERVAL 90 DAY) >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = 'Current' THEN 0 WHEN (CASE WHEN CAST(({{ due_day }}) AS DATE) >= CAST(({{ as_of }}) AS DATE) THEN 'Current' WHEN DATE_ADD(CAST(({{ due_day }}) AS DATE), INTERVAL 30 DAY) >= CAST(({{ as_of }}) AS DATE) THEN '1-30' WHEN DATE_ADD(CAST(({{ due_day }}) AS DATE), INTERVAL 60 DAY) >= CAST(({{ as_of }}) AS DATE) THEN '31-60' WHEN DATE_ADD(CAST(({{ due_day }}) AS DATE), INTERVAL 90 DAY) >= CAST(({{ as_of }}) AS DATE) THEN '61-90' ELSE '90+' END) = '1-30' THEN 0.015 ELSE 0.03 END, 2) END

ROUND({{ amount }} * CASE WHEN ((EXTRACT(YEAR FROM ({{ as_of }})) - EXTRACT(YEAR FROM ({{ start_day }}))) * 12 + EXTRACT(MONTH FROM ({{ as_of }})) - EXTRACT(MONTH FROM ({{ start_day }}))) >= {{ term_months }} THEN 1 WHEN ((EXTRACT(YEAR FROM ({{ as_of }})) - EXTRACT(YEAR FROM ({{ start_day }}))) * 12 + EXTRACT(MONTH FROM ({{ as_of }})) - EXTRACT(MONTH FROM ({{ start_day }}))) <= 0 THEN 0 ELSE ((EXTRACT(YEAR FROM ({{ as_of }})) - EXTRACT(YEAR FROM ({{ start_day }}))) * 12 + EXTRACT(MONTH FROM ({{ as_of }})) - EXTRACT(MONTH FROM ({{ start_day }}))) / {{ term_months }} END, 2)

ROUND({{ amount }} * CASE WHEN ((EXTRACT(YEAR FROM ({{ as_of }})) - EXTRACT(YEAR FROM ({{ start_day }}))) * 12 + EXTRACT(MONTH FROM ({{ as_of }})) - EXTRACT(MONTH FROM ({{ start_day }}))) >= {{ term_months }} THEN 1 WHEN ((EXTRACT(YEAR FROM ({{ as_of }})) - EXTRACT(YEAR FROM ({{ start_day }}))) * 12 + EXTRACT(MONTH FROM ({{ as_of }})) - EXTRACT(MONTH FROM ({{ start_day }}))) <= 0 THEN 0 ELSE CAST(((EXTRACT(YEAR FROM ({{ as_of }})) - EXTRACT(YEAR FROM ({{ start_day }}))) * 12 + EXTRACT(MONTH FROM ({{ as_of }})) - EXTRACT(MONTH FROM ({{ start_day }}))) AS BIGNUMERIC) / {{ term_months }} END, 2)

ROUND({{ amount }} * CASE WHEN ((EXTRACT(YEAR FROM ({{ as_of }})) - EXTRACT(YEAR FROM ({{ start_day }}))) * 12 + EXTRACT(MONTH FROM ({{ as_of }})) - EXTRACT(MONTH FROM ({{ start_day }}))) >= {{ term_months }} THEN 1 WHEN ((EXTRACT(YEAR FROM ({{ as_of }})) - EXTRACT(YEAR FROM ({{ start_day }}))) * 12 + EXTRACT(MONTH FROM ({{ as_of }})) - EXTRACT(MONTH FROM ({{ start_day }}))) <= 0 THEN 0 ELSE CAST(((EXTRACT(YEAR FROM ({{ as_of }})) - EXTRACT(YEAR FROM ({{ start_day }}))) * 12 + EXTRACT(MONTH FROM ({{ as_of }})) - EXTRACT(MONTH FROM ({{ start_day }}))) AS DECIMAL(38, 10)) / {{ term_months }} END, 2)

ROUND({{ amount }} * CASE WHEN ((EXTRACT(YEAR FROM ({{ as_of }})) - EXTRACT(YEAR FROM ({{ start_day }}))) * 12 + EXTRACT(MONTH FROM ({{ as_of }})) - EXTRACT(MONTH FROM ({{ start_day }}))) >= {{ term_months }} THEN 1 WHEN ((EXTRACT(YEAR FROM ({{ as_of }})) - EXTRACT(YEAR FROM ({{ start_day }}))) * 12 + EXTRACT(MONTH FROM ({{ as_of }})) - EXTRACT(MONTH FROM ({{ start_day }}))) <= 0 THEN 0 ELSE CAST(((EXTRACT(YEAR FROM ({{ as_of }})) - EXTRACT(YEAR FROM ({{ start_day }}))) * 12 + EXTRACT(MONTH FROM ({{ as_of }})) - EXTRACT(MONTH FROM ({{ start_day }}))) AS DECIMAL(38, 10)) / {{ term_months }} END, 2)

ROUND(CAST({{ amount }} * CASE WHEN ((EXTRACT(YEAR FROM ({{ as_of }})) - EXTRACT(YEAR FROM ({{ start_day }}))) * 12 + EXTRACT(MONTH FROM ({{ as_of }})) - EXTRACT(MONTH FROM ({{ start_day }}))) >= {{ term_months }} THEN 1 WHEN ((EXTRACT(YEAR FROM ({{ as_of }})) - EXTRACT(YEAR FROM ({{ start_day }}))) * 12 + EXTRACT(MONTH FROM ({{ as_of }})) - EXTRACT(MONTH FROM ({{ start_day }}))) <= 0 THEN 0 ELSE CAST(((EXTRACT(YEAR FROM ({{ as_of }})) - EXTRACT(YEAR FROM ({{ start_day }}))) * 12 + EXTRACT(MONTH FROM ({{ as_of }})) - EXTRACT(MONTH FROM ({{ start_day }}))) AS NUMERIC) / {{ term_months }} END AS NUMERIC), 2)

ROUND({{ amount }} * CASE WHEN ((DATEPART(year, ({{ as_of }})) - DATEPART(year, ({{ start_day }}))) * 12 + DATEPART(month, ({{ as_of }})) - DATEPART(month, ({{ start_day }}))) >= {{ term_months }} THEN 1 WHEN ((DATEPART(year, ({{ as_of }})) - DATEPART(year, ({{ start_day }}))) * 12 + DATEPART(month, ({{ as_of }})) - DATEPART(month, ({{ start_day }}))) <= 0 THEN 0 ELSE CAST(((DATEPART(year, ({{ as_of }})) - DATEPART(year, ({{ start_day }}))) * 12 + DATEPART(month, ({{ as_of }})) - DATEPART(month, ({{ start_day }}))) AS DECIMAL(38, 10)) / {{ term_months }} END, 2)

ROUND({{ amount }} * CASE WHEN ((EXTRACT(YEAR FROM ({{ as_of }})) - EXTRACT(YEAR FROM ({{ start_day }}))) * 12 + EXTRACT(MONTH FROM ({{ as_of }})) - EXTRACT(MONTH FROM ({{ start_day }}))) >= {{ term_months }} THEN 1 WHEN ((EXTRACT(YEAR FROM ({{ as_of }})) - EXTRACT(YEAR FROM ({{ start_day }}))) * 12 + EXTRACT(MONTH FROM ({{ as_of }})) - EXTRACT(MONTH FROM ({{ start_day }}))) <= 0 THEN 0 ELSE ((EXTRACT(YEAR FROM ({{ as_of }})) - EXTRACT(YEAR FROM ({{ start_day }}))) * 12 + EXTRACT(MONTH FROM ({{ as_of }})) - EXTRACT(MONTH FROM ({{ start_day }}))) / {{ term_months }} END, 2)

ROUND({{ amount }} * CASE WHEN ((EXTRACT(YEAR FROM ({{ as_of }})) - EXTRACT(YEAR FROM ({{ start_day }}))) * 12 + EXTRACT(MONTH FROM ({{ as_of }})) - EXTRACT(MONTH FROM ({{ start_day }}))) >= {{ term_months }} THEN 1 WHEN ((EXTRACT(YEAR FROM ({{ as_of }})) - EXTRACT(YEAR FROM ({{ start_day }}))) * 12 + EXTRACT(MONTH FROM ({{ as_of }})) - EXTRACT(MONTH FROM ({{ start_day }}))) <= 0 THEN 0 ELSE ((EXTRACT(YEAR FROM ({{ as_of }})) - EXTRACT(YEAR FROM ({{ start_day }}))) * 12 + EXTRACT(MONTH FROM ({{ as_of }})) - EXTRACT(MONTH FROM ({{ start_day }}))) / {{ term_months }} END, 2)

ROUND({{ amount }} - (ROUND(({{ amount }}) * CASE WHEN ((EXTRACT(YEAR FROM (({{ as_of }}))) - EXTRACT(YEAR FROM (({{ start_day }})))) * 12 + EXTRACT(MONTH FROM (({{ as_of }}))) - EXTRACT(MONTH FROM (({{ start_day }})))) >= ({{ term_months }}) THEN 1 WHEN ((EXTRACT(YEAR FROM (({{ as_of }}))) - EXTRACT(YEAR FROM (({{ start_day }})))) * 12 + EXTRACT(MONTH FROM (({{ as_of }}))) - EXTRACT(MONTH FROM (({{ start_day }})))) <= 0 THEN 0 ELSE ((EXTRACT(YEAR FROM (({{ as_of }}))) - EXTRACT(YEAR FROM (({{ start_day }})))) * 12 + EXTRACT(MONTH FROM (({{ as_of }}))) - EXTRACT(MONTH FROM (({{ start_day }})))) / ({{ term_months }}) END, 2)), 2)

ROUND({{ amount }} - (ROUND(({{ amount }}) * CASE WHEN ((EXTRACT(YEAR FROM (({{ as_of }}))) - EXTRACT(YEAR FROM (({{ start_day }})))) * 12 + EXTRACT(MONTH FROM (({{ as_of }}))) - EXTRACT(MONTH FROM (({{ start_day }})))) >= ({{ term_months }}) THEN 1 WHEN ((EXTRACT(YEAR FROM (({{ as_of }}))) - EXTRACT(YEAR FROM (({{ start_day }})))) * 12 + EXTRACT(MONTH FROM (({{ as_of }}))) - EXTRACT(MONTH FROM (({{ start_day }})))) <= 0 THEN 0 ELSE CAST(((EXTRACT(YEAR FROM (({{ as_of }}))) - EXTRACT(YEAR FROM (({{ start_day }})))) * 12 + EXTRACT(MONTH FROM (({{ as_of }}))) - EXTRACT(MONTH FROM (({{ start_day }})))) AS BIGNUMERIC) / ({{ term_months }}) END, 2)), 2)

ROUND({{ amount }} - (ROUND(({{ amount }}) * CASE WHEN ((EXTRACT(YEAR FROM (({{ as_of }}))) - EXTRACT(YEAR FROM (({{ start_day }})))) * 12 + EXTRACT(MONTH FROM (({{ as_of }}))) - EXTRACT(MONTH FROM (({{ start_day }})))) >= ({{ term_months }}) THEN 1 WHEN ((EXTRACT(YEAR FROM (({{ as_of }}))) - EXTRACT(YEAR FROM (({{ start_day }})))) * 12 + EXTRACT(MONTH FROM (({{ as_of }}))) - EXTRACT(MONTH FROM (({{ start_day }})))) <= 0 THEN 0 ELSE CAST(((EXTRACT(YEAR FROM (({{ as_of }}))) - EXTRACT(YEAR FROM (({{ start_day }})))) * 12 + EXTRACT(MONTH FROM (({{ as_of }}))) - EXTRACT(MONTH FROM (({{ start_day }})))) AS DECIMAL(38, 10)) / ({{ term_months }}) END, 2)), 2)

ROUND({{ amount }} - (ROUND(({{ amount }}) * CASE WHEN ((EXTRACT(YEAR FROM (({{ as_of }}))) - EXTRACT(YEAR FROM (({{ start_day }})))) * 12 + EXTRACT(MONTH FROM (({{ as_of }}))) - EXTRACT(MONTH FROM (({{ start_day }})))) >= ({{ term_months }}) THEN 1 WHEN ((EXTRACT(YEAR FROM (({{ as_of }}))) - EXTRACT(YEAR FROM (({{ start_day }})))) * 12 + EXTRACT(MONTH FROM (({{ as_of }}))) - EXTRACT(MONTH FROM (({{ start_day }})))) <= 0 THEN 0 ELSE CAST(((EXTRACT(YEAR FROM (({{ as_of }}))) - EXTRACT(YEAR FROM (({{ start_day }})))) * 12 + EXTRACT(MONTH FROM (({{ as_of }}))) - EXTRACT(MONTH FROM (({{ start_day }})))) AS DECIMAL(38, 10)) / ({{ term_months }}) END, 2)), 2)

ROUND(CAST({{ amount }} - (ROUND(CAST(({{ amount }}) * CASE WHEN ((EXTRACT(YEAR FROM (({{ as_of }}))) - EXTRACT(YEAR FROM (({{ start_day }})))) * 12 + EXTRACT(MONTH FROM (({{ as_of }}))) - EXTRACT(MONTH FROM (({{ start_day }})))) >= ({{ term_months }}) THEN 1 WHEN ((EXTRACT(YEAR FROM (({{ as_of }}))) - EXTRACT(YEAR FROM (({{ start_day }})))) * 12 + EXTRACT(MONTH FROM (({{ as_of }}))) - EXTRACT(MONTH FROM (({{ start_day }})))) <= 0 THEN 0 ELSE CAST(((EXTRACT(YEAR FROM (({{ as_of }}))) - EXTRACT(YEAR FROM (({{ start_day }})))) * 12 + EXTRACT(MONTH FROM (({{ as_of }}))) - EXTRACT(MONTH FROM (({{ start_day }})))) AS NUMERIC) / ({{ term_months }}) END AS NUMERIC), 2)) AS NUMERIC), 2)

ROUND({{ amount }} - (ROUND(({{ amount }}) * CASE WHEN ((DATEPART(year, (({{ as_of }}))) - DATEPART(year, (({{ start_day }})))) * 12 + DATEPART(month, (({{ as_of }}))) - DATEPART(month, (({{ start_day }})))) >= ({{ term_months }}) THEN 1 WHEN ((DATEPART(year, (({{ as_of }}))) - DATEPART(year, (({{ start_day }})))) * 12 + DATEPART(month, (({{ as_of }}))) - DATEPART(month, (({{ start_day }})))) <= 0 THEN 0 ELSE CAST(((DATEPART(year, (({{ as_of }}))) - DATEPART(year, (({{ start_day }})))) * 12 + DATEPART(month, (({{ as_of }}))) - DATEPART(month, (({{ start_day }})))) AS DECIMAL(38, 10)) / ({{ term_months }}) END, 2)), 2)

ROUND({{ amount }} - (ROUND(({{ amount }}) * CASE WHEN ((EXTRACT(YEAR FROM (({{ as_of }}))) - EXTRACT(YEAR FROM (({{ start_day }})))) * 12 + EXTRACT(MONTH FROM (({{ as_of }}))) - EXTRACT(MONTH FROM (({{ start_day }})))) >= ({{ term_months }}) THEN 1 WHEN ((EXTRACT(YEAR FROM (({{ as_of }}))) - EXTRACT(YEAR FROM (({{ start_day }})))) * 12 + EXTRACT(MONTH FROM (({{ as_of }}))) - EXTRACT(MONTH FROM (({{ start_day }})))) <= 0 THEN 0 ELSE ((EXTRACT(YEAR FROM (({{ as_of }}))) - EXTRACT(YEAR FROM (({{ start_day }})))) * 12 + EXTRACT(MONTH FROM (({{ as_of }}))) - EXTRACT(MONTH FROM (({{ start_day }})))) / ({{ term_months }}) END, 2)), 2)

ROUND({{ amount }} - (ROUND(({{ amount }}) * CASE WHEN ((EXTRACT(YEAR FROM (({{ as_of }}))) - EXTRACT(YEAR FROM (({{ start_day }})))) * 12 + EXTRACT(MONTH FROM (({{ as_of }}))) - EXTRACT(MONTH FROM (({{ start_day }})))) >= ({{ term_months }}) THEN 1 WHEN ((EXTRACT(YEAR FROM (({{ as_of }}))) - EXTRACT(YEAR FROM (({{ start_day }})))) * 12 + EXTRACT(MONTH FROM (({{ as_of }}))) - EXTRACT(MONTH FROM (({{ start_day }})))) <= 0 THEN 0 ELSE ((EXTRACT(YEAR FROM (({{ as_of }}))) - EXTRACT(YEAR FROM (({{ start_day }})))) * 12 + EXTRACT(MONTH FROM (({{ as_of }}))) - EXTRACT(MONTH FROM (({{ start_day }})))) / ({{ term_months }}) END, 2)), 2)

CASE WHEN {{ days_since_order }} > 120 THEN 'Win-back: 20% off' WHEN {{ tier }} = 'Platinum' THEN CONCAT('Early access: ', COALESCE(CAST({{ last_category }} AS VARCHAR), '')) WHEN LOWER({{ last_category }}) = 'tents' THEN 'Sleeping bag bundle' WHEN LOWER({{ last_category }}) = 'footwear' THEN 'Trail socks 3-pack' ELSE 'Free shipping on the next order' END

CASE WHEN {{ days_since_order }} > 120 THEN 'Win-back: 20% off' WHEN {{ tier }} = 'Platinum' THEN CONCAT('Early access: ', COALESCE(CAST({{ last_category }} AS STRING), '')) WHEN LOWER({{ last_category }}) = 'tents' THEN 'Sleeping bag bundle' WHEN LOWER({{ last_category }}) = 'footwear' THEN 'Trail socks 3-pack' ELSE 'Free shipping on the next order' END

CASE WHEN {{ days_since_order }} > 120 THEN 'Win-back: 20% off' WHEN {{ tier }} = 'Platinum' THEN CONCAT('Early access: ', COALESCE(CAST({{ last_category }} AS STRING), '')) WHEN LOWER({{ last_category }}) = 'tents' THEN 'Sleeping bag bundle' WHEN LOWER({{ last_category }}) = 'footwear' THEN 'Trail socks 3-pack' ELSE 'Free shipping on the next order' END

CASE WHEN {{ days_since_order }} > 120 THEN 'Win-back: 20% off' WHEN {{ tier }} = 'Platinum' THEN ('Early access: ' || COALESCE(CAST({{ last_category }} AS VARCHAR), '')) WHEN LOWER({{ last_category }}) = 'tents' THEN 'Sleeping bag bundle' WHEN LOWER({{ last_category }}) = 'footwear' THEN 'Trail socks 3-pack' ELSE 'Free shipping on the next order' END

CASE WHEN {{ days_since_order }} > 120 THEN 'Win-back: 20% off' WHEN {{ tier }} = 'Platinum' THEN CONCAT('Early access: ', {{ last_category }}) WHEN LOWER({{ last_category }}) = 'tents' THEN 'Sleeping bag bundle' WHEN LOWER({{ last_category }}) = 'footwear' THEN 'Trail socks 3-pack' ELSE 'Free shipping on the next order' END

CASE WHEN {{ days_since_order }} > 120 THEN 'Win-back: 20% off' WHEN {{ tier }} = 'Platinum' THEN CONCAT('Early access: ', {{ last_category }}) WHEN LOWER({{ last_category }}) = 'tents' THEN 'Sleeping bag bundle' WHEN LOWER({{ last_category }}) = 'footwear' THEN 'Trail socks 3-pack' ELSE 'Free shipping on the next order' END

CASE WHEN {{ days_since_order }} > 120 THEN 'Win-back: 20% off' WHEN {{ tier }} = 'Platinum' THEN ('Early access: ' || {{ last_category }}) WHEN LOWER({{ last_category }}) = 'tents' THEN 'Sleeping bag bundle' WHEN LOWER({{ last_category }}) = 'footwear' THEN 'Trail socks 3-pack' ELSE 'Free shipping on the next order' END

CASE WHEN {{ days_since_order }} > 120 THEN 'Win-back: 20% off' WHEN {{ tier }} = 'Platinum' THEN CONCAT('Early access: ', COALESCE(CAST({{ last_category }} AS CHAR), '')) WHEN LOWER({{ last_category }}) = 'tents' THEN 'Sleeping bag bundle' WHEN LOWER({{ last_category }}) = 'footwear' THEN 'Trail socks 3-pack' ELSE 'Free shipping on the next order' END

CASE WHEN (CASE WHEN (({{ days_since_order }}) > 180 OR ({{ nps }}) <= 6) THEN 'High' WHEN (({{ days_since_order }}) > 90 OR ({{ tickets_open }}) >= 2) THEN 'Medium' ELSE 'Low' END) = 'High' THEN 'At risk' WHEN (LOWER((CASE WHEN (({{ lifetime_spend }}) >= 5000 AND ({{ orders }}) >= 20) THEN 'Platinum' WHEN ({{ lifetime_spend }}) >= 2000 THEN 'Gold' WHEN ({{ orders }}) >= 3 THEN 'Silver' ELSE 'Bronze' END)) IN (LOWER('Platinum'), LOWER('Gold')) AND (CASE WHEN (({{ days_since_order }}) > 180 OR ({{ nps }}) <= 6) THEN 'High' WHEN (({{ days_since_order }}) > 90 OR ({{ tickets_open }}) >= 2) THEN 'Medium' ELSE 'Low' END) = 'Low') THEN 'Healthy' ELSE 'Watch' END

CASE WHEN (CASE WHEN (({{ days_since_order }}) > 180 OR ({{ nps }}) <= 6) THEN 'High' WHEN (({{ days_since_order }}) > 90 OR ({{ tickets_open }}) >= 2) THEN 'Medium' ELSE 'Low' END) = 'High' THEN 'At risk' WHEN (LOWER((CASE WHEN (({{ lifetime_spend }}) >= 5000 AND ({{ orders }}) >= 20) THEN 'Platinum' WHEN ({{ lifetime_spend }}) >= 2000 THEN 'Gold' WHEN ({{ orders }}) >= 3 THEN 'Silver' ELSE 'Bronze' END)) IN (LOWER('Platinum'), LOWER('Gold')) AND (CASE WHEN (({{ days_since_order }}) > 180 OR ({{ nps }}) <= 6) THEN 'High' WHEN (({{ days_since_order }}) > 90 OR ({{ tickets_open }}) >= 2) THEN 'Medium' ELSE 'Low' END) = 'Low') THEN 'Healthy' ELSE 'Watch' END

CASE WHEN (CASE WHEN (({{ days_since_order }}) > 180 OR ({{ nps }}) <= 6) THEN 'High' WHEN (({{ days_since_order }}) > 90 OR ({{ tickets_open }}) >= 2) THEN 'Medium' ELSE 'Low' END) = 'High' THEN 'At risk' WHEN (LOWER((CASE WHEN (({{ lifetime_spend }}) >= 5000 AND ({{ orders }}) >= 20) THEN 'Platinum' WHEN ({{ lifetime_spend }}) >= 2000 THEN 'Gold' WHEN ({{ orders }}) >= 3 THEN 'Silver' ELSE 'Bronze' END)) IN (LOWER('Platinum'), LOWER('Gold')) AND (CASE WHEN (({{ days_since_order }}) > 180 OR ({{ nps }}) <= 6) THEN 'High' WHEN (({{ days_since_order }}) > 90 OR ({{ tickets_open }}) >= 2) THEN 'Medium' ELSE 'Low' END) = 'Low') THEN 'Healthy' ELSE 'Watch' END

CASE WHEN (CASE WHEN (({{ days_since_order }}) > 180 OR ({{ nps }}) <= 6) THEN 'High' WHEN (({{ days_since_order }}) > 90 OR ({{ tickets_open }}) >= 2) THEN 'Medium' ELSE 'Low' END) = 'High' THEN 'At risk' WHEN (LOWER((CASE WHEN (({{ lifetime_spend }}) >= 5000 AND ({{ orders }}) >= 20) THEN 'Platinum' WHEN ({{ lifetime_spend }}) >= 2000 THEN 'Gold' WHEN ({{ orders }}) >= 3 THEN 'Silver' ELSE 'Bronze' END)) IN (LOWER('Platinum'), LOWER('Gold')) AND (CASE WHEN (({{ days_since_order }}) > 180 OR ({{ nps }}) <= 6) THEN 'High' WHEN (({{ days_since_order }}) > 90 OR ({{ tickets_open }}) >= 2) THEN 'Medium' ELSE 'Low' END) = 'Low') THEN 'Healthy' ELSE 'Watch' END

CASE WHEN (CASE WHEN (({{ days_since_order }}) > 180 OR ({{ nps }}) <= 6) THEN 'High' WHEN (({{ days_since_order }}) > 90 OR ({{ tickets_open }}) >= 2) THEN 'Medium' ELSE 'Low' END) = 'High' THEN 'At risk' WHEN (LOWER((CASE WHEN (({{ lifetime_spend }}) >= 5000 AND ({{ orders }}) >= 20) THEN 'Platinum' WHEN ({{ lifetime_spend }}) >= 2000 THEN 'Gold' WHEN ({{ orders }}) >= 3 THEN 'Silver' ELSE 'Bronze' END)) IN (LOWER('Platinum'), LOWER('Gold')) AND (CASE WHEN (({{ days_since_order }}) > 180 OR ({{ nps }}) <= 6) THEN 'High' WHEN (({{ days_since_order }}) > 90 OR ({{ tickets_open }}) >= 2) THEN 'Medium' ELSE 'Low' END) = 'Low') THEN 'Healthy' ELSE 'Watch' END

CASE WHEN (CASE WHEN (({{ days_since_order }}) > 180 OR ({{ nps }}) <= 6) THEN 'High' WHEN (({{ days_since_order }}) > 90 OR ({{ tickets_open }}) >= 2) THEN 'Medium' ELSE 'Low' END) = 'High' THEN 'At risk' WHEN (LOWER((CASE WHEN (({{ lifetime_spend }}) >= 5000 AND ({{ orders }}) >= 20) THEN 'Platinum' WHEN ({{ lifetime_spend }}) >= 2000 THEN 'Gold' WHEN ({{ orders }}) >= 3 THEN 'Silver' ELSE 'Bronze' END)) IN (LOWER('Platinum'), LOWER('Gold')) AND (CASE WHEN (({{ days_since_order }}) > 180 OR ({{ nps }}) <= 6) THEN 'High' WHEN (({{ days_since_order }}) > 90 OR ({{ tickets_open }}) >= 2) THEN 'Medium' ELSE 'Low' END) = 'Low') THEN 'Healthy' ELSE 'Watch' END

CASE WHEN (CASE WHEN (({{ days_since_order }}) > 180 OR ({{ nps }}) <= 6) THEN 'High' WHEN (({{ days_since_order }}) > 90 OR ({{ tickets_open }}) >= 2) THEN 'Medium' ELSE 'Low' END) = 'High' THEN 'At risk' WHEN (LOWER((CASE WHEN (({{ lifetime_spend }}) >= 5000 AND ({{ orders }}) >= 20) THEN 'Platinum' WHEN ({{ lifetime_spend }}) >= 2000 THEN 'Gold' WHEN ({{ orders }}) >= 3 THEN 'Silver' ELSE 'Bronze' END)) IN (LOWER('Platinum'), LOWER('Gold')) AND (CASE WHEN (({{ days_since_order }}) > 180 OR ({{ nps }}) <= 6) THEN 'High' WHEN (({{ days_since_order }}) > 90 OR ({{ tickets_open }}) >= 2) THEN 'Medium' ELSE 'Low' END) = 'Low') THEN 'Healthy' ELSE 'Watch' END

CASE WHEN (CASE WHEN (({{ days_since_order }}) > 180 OR ({{ nps }}) <= 6) THEN 'High' WHEN (({{ days_since_order }}) > 90 OR ({{ tickets_open }}) >= 2) THEN 'Medium' ELSE 'Low' END) = 'High' THEN 'At risk' WHEN (LOWER((CASE WHEN (({{ lifetime_spend }}) >= 5000 AND ({{ orders }}) >= 20) THEN 'Platinum' WHEN ({{ lifetime_spend }}) >= 2000 THEN 'Gold' WHEN ({{ orders }}) >= 3 THEN 'Silver' ELSE 'Bronze' END)) IN (LOWER('Platinum'), LOWER('Gold')) AND (CASE WHEN (({{ days_since_order }}) > 180 OR ({{ nps }}) <= 6) THEN 'High' WHEN (({{ days_since_order }}) > 90 OR ({{ tickets_open }}) >= 2) THEN 'Medium' ELSE 'Low' END) = 'Low') THEN 'Healthy' ELSE 'Watch' END

REPLACE(REPLACE(TRIM({{ text }}), '  ', ' '), '  ', ' ')

REPLACE(REPLACE(TRIM({{ text }}), '  ', ' '), '  ', ' ')

REPLACE(REPLACE(TRIM({{ text }}), '  ', ' '), '  ', ' ')

REPLACE(REPLACE(TRIM({{ text }}), '  ', ' '), '  ', ' ')

REPLACE(REPLACE(TRIM({{ text }}), '  ', ' '), '  ', ' ')

REPLACE(REPLACE(TRIM({{ text }}), '  ', ' '), '  ', ' ')

REPLACE(REPLACE(TRIM({{ text }}), '  ', ' '), '  ', ' ')

REPLACE(REPLACE(TRIM({{ text }}), '  ', ' '), '  ', ' ')

REPLACE({{ text }}, '''', '')

REPLACE({{ text }}, '\'', '')

REPLACE({{ text }}, '''', '')

REPLACE({{ text }}, '''', '')

REPLACE({{ text }}, '''', '')

REPLACE({{ text }}, '''', '')

REPLACE({{ text }}, '''', '')

REPLACE({{ text }}, '''', '')

UPPER(LEFT(TRIM({{ text }}), 1))

UPPER(LEFT(TRIM({{ text }}), 1))

UPPER(LEFT(TRIM({{ text }}), 1))

UPPER(LEFT(TRIM({{ text }}), 1))

UPPER(LEFT(TRIM({{ text }}), 1))

UPPER(LEFT(TRIM({{ text }}), 1))

UPPER(SUBSTR(TRIM({{ text }}), 1, 1))

UPPER(LEFT(TRIM({{ text }}), 1))

LOWER(UPPER(TRIM({{ value }}))) IN (LOWER('Y'), LOWER('YES'), LOWER('TRUE'), LOWER('1'))

LOWER(UPPER(TRIM({{ value }}))) IN (LOWER('Y'), LOWER('YES'), LOWER('TRUE'), LOWER('1'))

LOWER(UPPER(TRIM({{ value }}))) IN (LOWER('Y'), LOWER('YES'), LOWER('TRUE'), LOWER('1'))

LOWER(UPPER(TRIM({{ value }}))) IN (LOWER('Y'), LOWER('YES'), LOWER('TRUE'), LOWER('1'))

LOWER(UPPER(TRIM({{ value }}))) IN (LOWER('Y'), LOWER('YES'), LOWER('TRUE'), LOWER('1'))

LOWER(UPPER(TRIM({{ value }}))) IN (LOWER('Y'), LOWER('YES'), LOWER('TRUE'), LOWER('1'))

LOWER(UPPER(TRIM({{ value }}))) IN (LOWER('Y'), LOWER('YES'), LOWER('TRUE'), LOWER('1'))

LOWER(UPPER(TRIM({{ value }}))) IN (LOWER('Y'), LOWER('YES'), LOWER('TRUE'), LOWER('1'))

COALESCE({{ amount }}, 0)

COALESCE({{ amount }}, 0)

COALESCE({{ amount }}, 0)

COALESCE({{ amount }}, 0)

COALESCE({{ amount }}, 0)

COALESCE({{ amount }}, 0)

COALESCE({{ amount }}, 0)

COALESCE({{ amount }}, 0)

FLOOR(CAST(TRIM({{ text }}) AS NUMBER(38, 10)))

FLOOR(CAST(TRIM({{ text }}) AS NUMERIC))

FLOOR(CAST(TRIM({{ text }}) AS DECIMAL(38, 10)))

FLOOR(CAST(TRIM({{ text }}) AS DECIMAL(38, 10)))

FLOOR(CAST(TRIM({{ text }}) AS NUMERIC))

FLOOR(CAST(TRIM({{ text }}) AS DECIMAL(38, 10)))

FLOOR(CAST(TRIM({{ text }}) AS NUMBER))

FLOOR(CAST(TRIM({{ text }}) AS DECIMAL(38, 10)))

{{ pct }} / 100

CAST({{ pct }} AS BIGNUMERIC) / 100

CAST({{ pct }} AS DECIMAL(38, 10)) / 100

CAST({{ pct }} AS DECIMAL(38, 10)) / 100

CAST({{ pct }} AS NUMERIC) / 100

CAST({{ pct }} AS DECIMAL(38, 10)) / 100

{{ pct }} / 100

{{ pct }} / 100

ROUND({{ rate }} * 100, 2)

ROUND({{ rate }} * 100, 2)

ROUND({{ rate }} * 100, 2)

ROUND({{ rate }} * 100, 2)

ROUND(CAST({{ rate }} * 100 AS NUMERIC), 2)

ROUND({{ rate }} * 100, 2)

ROUND({{ rate }} * 100, 2)

ROUND({{ rate }} * 100, 2)

ROUND({{ bill }} * {{ pct }} / 100, 2)

ROUND(CAST({{ bill }} * {{ pct }} AS BIGNUMERIC) / 100, 2)

ROUND(CAST({{ bill }} * {{ pct }} AS DECIMAL(38, 10)) / 100, 2)

ROUND(CAST({{ bill }} * {{ pct }} AS DECIMAL(38, 10)) / 100, 2)

ROUND(CAST(CAST({{ bill }} * {{ pct }} AS NUMERIC) / 100 AS NUMERIC), 2)

ROUND(CAST({{ bill }} * {{ pct }} AS DECIMAL(38, 10)) / 100, 2)

ROUND({{ bill }} * {{ pct }} / 100, 2)

ROUND({{ bill }} * {{ pct }} / 100, 2)

ROUND({{ amount }} * {{ rate }}, 2)

ROUND({{ amount }} * {{ rate }}, 2)

ROUND({{ amount }} * {{ rate }}, 2)

ROUND({{ amount }} * {{ rate }}, 2)

ROUND(CAST({{ amount }} * {{ rate }} AS NUMERIC), 2)

ROUND({{ amount }} * {{ rate }}, 2)

ROUND({{ amount }} * {{ rate }}, 2)

ROUND({{ amount }} * {{ rate }}, 2)

ROUND({{ cost }} * (1 + {{ markup_pct }} / 100), 2)

ROUND({{ cost }} * (1 + CAST({{ markup_pct }} AS BIGNUMERIC) / 100), 2)

ROUND({{ cost }} * (1 + CAST({{ markup_pct }} AS DECIMAL(38, 10)) / 100), 2)

ROUND({{ cost }} * (1 + CAST({{ markup_pct }} AS DECIMAL(38, 10)) / 100), 2)

ROUND(CAST({{ cost }} * (1 + CAST({{ markup_pct }} AS NUMERIC) / 100) AS NUMERIC), 2)

ROUND({{ cost }} * (1 + CAST({{ markup_pct }} AS DECIMAL(38, 10)) / 100), 2)

ROUND({{ cost }} * (1 + {{ markup_pct }} / 100), 2)

ROUND({{ cost }} * (1 + {{ markup_pct }} / 100), 2)

ROUND({{ amount }} * 20, 0) / 20

CAST(ROUND({{ amount }} * 20, 0) AS BIGNUMERIC) / 20

CAST(ROUND({{ amount }} * 20, 0) AS DECIMAL(38, 10)) / 20

CAST(ROUND({{ amount }} * 20, 0) AS DECIMAL(38, 10)) / 20

CAST(ROUND(CAST({{ amount }} * 20 AS NUMERIC), 0) AS NUMERIC) / 20

CAST(ROUND({{ amount }} * 20, 0) AS DECIMAL(38, 10)) / 20

ROUND({{ amount }} * 20, 0) / 20

ROUND({{ amount }} * 20, 0) / 20

EXTRACT(DAY FROM {{ day }})

EXTRACT(DAY FROM {{ day }})

EXTRACT(DAY FROM {{ day }})

EXTRACT(DAY FROM {{ day }})

EXTRACT(DAY FROM {{ day }})

DATEPART(day, {{ day }})

EXTRACT(DAY FROM {{ day }})

EXTRACT(DAY FROM {{ day }})

DATEADD(week, {{ weeks }}, CAST({{ day }} AS DATE))

DATE_ADD(CAST({{ day }} AS DATE), INTERVAL {{ weeks }} WEEK)

DATEADD(week, {{ weeks }}, CAST({{ day }} AS DATE))

(CAST({{ day }} AS DATE) + ({{ weeks }}) * INTERVAL '1 week')

(CAST({{ day }} AS DATE) + ({{ weeks }}) * INTERVAL '1 week')

DATEADD(week, {{ weeks }}, CAST({{ day }} AS DATE))

(CAST({{ day }} AS DATE) + NUMTODSINTERVAL({{ weeks }} * 7, 'DAY'))

DATE_ADD(CAST({{ day }} AS DATE), INTERVAL {{ weeks }} WEEK)

DATEADD(hour, {{ hours }}, {{ ts }})

DATE_ADD({{ ts }}, INTERVAL {{ hours }} HOUR)

DATEADD(hour, {{ hours }}, {{ ts }})

({{ ts }} + ({{ hours }}) * INTERVAL '1 hour')

({{ ts }} + ({{ hours }}) * INTERVAL '1 hour')

DATEADD(hour, {{ hours }}, {{ ts }})

({{ ts }} + NUMTODSINTERVAL({{ hours }}, 'HOUR'))

DATE_ADD({{ ts }}, INTERVAL {{ hours }} HOUR)

FLOOR({{ year }} / 10) * 10

FLOOR(CAST({{ year }} AS BIGNUMERIC) / 10) * 10

FLOOR(CAST({{ year }} AS DECIMAL(38, 10)) / 10) * 10

FLOOR(CAST({{ year }} AS DECIMAL(38, 10)) / 10) * 10

FLOOR(CAST({{ year }} AS NUMERIC) / 10) * 10

FLOOR(CAST({{ year }} AS DECIMAL(38, 10)) / 10) * 10

FLOOR({{ year }} / 10) * 10

FLOOR({{ year }} / 10) * 10

{{ subtotal }} >= {{ threshold }}

{{ subtotal }} >= {{ threshold }}

{{ subtotal }} >= {{ threshold }}

{{ subtotal }} >= {{ threshold }}

{{ subtotal }} >= {{ threshold }}

{{ subtotal }} >= {{ threshold }}

{{ subtotal }} >= {{ threshold }}

{{ subtotal }} >= {{ threshold }}

LOWER(TRIM({{ email }})) LIKE '%@harborlane.com' ESCAPE '!'

LOWER(TRIM({{ email }})) LIKE '%@harborlane.com'

LOWER(TRIM({{ email }})) LIKE '%@harborlane.com' ESCAPE '!'

LOWER(TRIM({{ email }})) LIKE '%@harborlane.com' ESCAPE '!'

LOWER(TRIM({{ email }})) LIKE '%@harborlane.com' ESCAPE '!'

LOWER(TRIM({{ email }})) LIKE '%@harborlane.com' ESCAPE '!'

LOWER(TRIM({{ email }})) LIKE '%@harborlane.com' ESCAPE '!'

LOWER(TRIM({{ email }})) LIKE '%@harborlane.com' ESCAPE '!'

UPPER(TRIM({{ sku }})) LIKE 'CLR-%' ESCAPE '!'

UPPER(TRIM({{ sku }})) LIKE 'CLR-%'

UPPER(TRIM({{ sku }})) LIKE 'CLR-%' ESCAPE '!'

UPPER(TRIM({{ sku }})) LIKE 'CLR-%' ESCAPE '!'

UPPER(TRIM({{ sku }})) LIKE 'CLR-%' ESCAPE '!'

UPPER(TRIM({{ sku }})) LIKE 'CLR-%' ESCAPE '!'

UPPER(TRIM({{ sku }})) LIKE 'CLR-%' ESCAPE '!'

UPPER(TRIM({{ sku }})) LIKE 'CLR-%' ESCAPE '!'

ROUND({{ on_hand }} * {{ unit_cost }}, 2)

ROUND({{ on_hand }} * {{ unit_cost }}, 2)

ROUND({{ on_hand }} * {{ unit_cost }}, 2)

ROUND({{ on_hand }} * {{ unit_cost }}, 2)

ROUND(CAST({{ on_hand }} * {{ unit_cost }} AS NUMERIC), 2)

ROUND({{ on_hand }} * {{ unit_cost }}, 2)

ROUND({{ on_hand }} * {{ unit_cost }}, 2)

ROUND({{ on_hand }} * {{ unit_cost }}, 2)

ROUND({{ lb }} / 2.20462, 2)

ROUND(CAST({{ lb }} AS BIGNUMERIC) / BIGNUMERIC '2.20462', 2)

ROUND(CAST({{ lb }} AS DECIMAL(38, 10)) / 2.20462, 2)

ROUND(CAST({{ lb }} AS DECIMAL(38, 10)) / 2.20462, 2)

ROUND(CAST(CAST({{ lb }} AS NUMERIC) / 2.20462 AS NUMERIC), 2)

ROUND(CAST({{ lb }} AS DECIMAL(38, 10)) / 2.20462, 2)

ROUND({{ lb }} / 2.20462, 2)

ROUND({{ lb }} / 2.20462, 2)

ROUND({{ miles }} * 1.609344, 1)

ROUND({{ miles }} * BIGNUMERIC '1.609344', 1)

ROUND({{ miles }} * 1.609344, 1)

ROUND({{ miles }} * 1.609344, 1)

ROUND(CAST({{ miles }} * 1.609344 AS NUMERIC), 1)

ROUND({{ miles }} * 1.609344, 1)

ROUND({{ miles }} * 1.609344, 1)

ROUND({{ miles }} * 1.609344, 1)

ROUND(({{ fahrenheit }} - 32) * 5 / 9, 1)

ROUND(CAST(({{ fahrenheit }} - 32) * 5 AS BIGNUMERIC) / 9, 1)

ROUND(CAST(({{ fahrenheit }} - 32) * 5 AS DECIMAL(38, 10)) / 9, 1)

ROUND(CAST(({{ fahrenheit }} - 32) * 5 AS DECIMAL(38, 10)) / 9, 1)

ROUND(CAST(CAST(({{ fahrenheit }} - 32) * 5 AS NUMERIC) / 9 AS NUMERIC), 1)

ROUND(CAST(({{ fahrenheit }} - 32) * 5 AS DECIMAL(38, 10)) / 9, 1)

ROUND(({{ fahrenheit }} - 32) * 5 / 9, 1)

ROUND(({{ fahrenheit }} - 32) * 5 / 9, 1)

{{ temp_f }} > {{ max_f }}

{{ temp_f }} > {{ max_f }}

{{ temp_f }} > {{ max_f }}

{{ temp_f }} > {{ max_f }}

{{ temp_f }} > {{ max_f }}

{{ temp_f }} > {{ max_f }}

{{ temp_f }} > {{ max_f }}

{{ temp_f }} > {{ max_f }}

{{ gross }} - {{ returns }} - {{ discounts }}

{{ gross }} - {{ returns }} - {{ discounts }}

{{ gross }} - {{ returns }} - {{ discounts }}

{{ gross }} - {{ returns }} - {{ discounts }}

{{ gross }} - {{ returns }} - {{ discounts }}

{{ gross }} - {{ returns }} - {{ discounts }}

{{ gross }} - {{ returns }} - {{ discounts }}

{{ gross }} - {{ returns }} - {{ discounts }}

{{ revenue }} - {{ cogs }} - {{ opex }}

{{ revenue }} - {{ cogs }} - {{ opex }}

{{ revenue }} - {{ cogs }} - {{ opex }}

{{ revenue }} - {{ cogs }} - {{ opex }}

{{ revenue }} - {{ cogs }} - {{ opex }}

{{ revenue }} - {{ cogs }} - {{ opex }}

{{ revenue }} - {{ cogs }} - {{ opex }}

{{ revenue }} - {{ cogs }} - {{ opex }}

ROUND({{ current_assets }} / {{ current_liabilities }}, 2)

ROUND(CAST({{ current_assets }} AS BIGNUMERIC) / {{ current_liabilities }}, 2)

ROUND(CAST({{ current_assets }} AS DECIMAL(38, 10)) / {{ current_liabilities }}, 2)

ROUND(CAST({{ current_assets }} AS DECIMAL(38, 10)) / {{ current_liabilities }}, 2)

ROUND(CAST(CAST({{ current_assets }} AS NUMERIC) / {{ current_liabilities }} AS NUMERIC), 2)

ROUND(CAST({{ current_assets }} AS DECIMAL(38, 10)) / {{ current_liabilities }}, 2)

ROUND({{ current_assets }} / {{ current_liabilities }}, 2)

ROUND({{ current_assets }} / {{ current_liabilities }}, 2)

ROUND({{ annual_price }} / 12, 2)

ROUND(CAST({{ annual_price }} AS BIGNUMERIC) / 12, 2)

ROUND(CAST({{ annual_price }} AS DECIMAL(38, 10)) / 12, 2)

ROUND(CAST({{ annual_price }} AS DECIMAL(38, 10)) / 12, 2)

ROUND(CAST(CAST({{ annual_price }} AS NUMERIC) / 12 AS NUMERIC), 2)

ROUND(CAST({{ annual_price }} AS DECIMAL(38, 10)) / 12, 2)

ROUND({{ annual_price }} / 12, 2)

ROUND({{ annual_price }} / 12, 2)

LOWER(TRIM({{ plan }})) LIKE 'trial%' ESCAPE '!'

LOWER(TRIM({{ plan }})) LIKE 'trial%'

LOWER(TRIM({{ plan }})) LIKE 'trial%' ESCAPE '!'

LOWER(TRIM({{ plan }})) LIKE 'trial%' ESCAPE '!'

LOWER(TRIM({{ plan }})) LIKE 'trial%' ESCAPE '!'

LOWER(TRIM({{ plan }})) LIKE 'trial%' ESCAPE '!'

LOWER(TRIM({{ plan }})) LIKE 'trial%' ESCAPE '!'

LOWER(TRIM({{ plan }})) LIKE 'trial%' ESCAPE '!'

{{ orders }} >= 2

{{ orders }} >= 2

{{ orders }} >= 2

{{ orders }} >= 2

{{ orders }} >= 2

{{ orders }} >= 2

{{ orders }} >= 2

{{ orders }} >= 2

{{ as_of_year }} - {{ birth_year }}

{{ as_of_year }} - {{ birth_year }}

{{ as_of_year }} - {{ birth_year }}

{{ as_of_year }} - {{ birth_year }}

{{ as_of_year }} - {{ birth_year }}

{{ as_of_year }} - {{ birth_year }}

{{ as_of_year }} - {{ birth_year }}

{{ as_of_year }} - {{ birth_year }}

ROUND({{ hourly }} * {{ hours_per_week }} * 52, 2)

ROUND({{ hourly }} * {{ hours_per_week }} * 52, 2)

ROUND({{ hourly }} * {{ hours_per_week }} * 52, 2)

ROUND({{ hourly }} * {{ hours_per_week }} * 52, 2)

ROUND(CAST({{ hourly }} * {{ hours_per_week }} * 52 AS NUMERIC), 2)

ROUND({{ hourly }} * {{ hours_per_week }} * 52, 2)

ROUND({{ hourly }} * {{ hours_per_week }} * 52, 2)

ROUND({{ hourly }} * {{ hours_per_week }} * 52, 2)

ROUND({{ hours_per_week }} / 40, 2)

ROUND(CAST({{ hours_per_week }} AS BIGNUMERIC) / 40, 2)

ROUND(CAST({{ hours_per_week }} AS DECIMAL(38, 10)) / 40, 2)

ROUND(CAST({{ hours_per_week }} AS DECIMAL(38, 10)) / 40, 2)

ROUND(CAST(CAST({{ hours_per_week }} AS NUMERIC) / 40 AS NUMERIC), 2)

ROUND(CAST({{ hours_per_week }} AS DECIMAL(38, 10)) / 40, 2)

ROUND({{ hours_per_week }} / 40, 2)

ROUND({{ hours_per_week }} / 40, 2)

LOWER(TRIM({{ value }}))

LOWER(TRIM({{ value }}))

LOWER(TRIM({{ value }}))

LOWER(TRIM({{ value }}))

LOWER(TRIM({{ value }}))

LOWER(TRIM({{ value }}))

LOWER(TRIM({{ value }}))

LOWER(TRIM({{ value }}))

CASE WHEN {{ impressions }} = 0 THEN 0 ELSE ROUND({{ clicks }} / {{ impressions }} * 100, 2) END

CASE WHEN {{ impressions }} = 0 THEN 0 ELSE ROUND(CAST({{ clicks }} AS BIGNUMERIC) / {{ impressions }} * 100, 2) END

CASE WHEN {{ impressions }} = 0 THEN 0 ELSE ROUND(CAST({{ clicks }} AS DECIMAL(38, 10)) / {{ impressions }} * 100, 2) END

CASE WHEN {{ impressions }} = 0 THEN 0 ELSE ROUND(CAST({{ clicks }} AS DECIMAL(38, 10)) / {{ impressions }} * 100, 2) END

CASE WHEN {{ impressions }} = 0 THEN 0 ELSE ROUND(CAST(CAST({{ clicks }} AS NUMERIC) / {{ impressions }} * 100 AS NUMERIC), 2) END

CASE WHEN {{ impressions }} = 0 THEN 0 ELSE ROUND(CAST({{ clicks }} AS DECIMAL(38, 10)) / {{ impressions }} * 100, 2) END

CASE WHEN {{ impressions }} = 0 THEN 0 ELSE ROUND({{ clicks }} / {{ impressions }} * 100, 2) END

CASE WHEN {{ impressions }} = 0 THEN 0 ELSE ROUND({{ clicks }} / {{ impressions }} * 100, 2) END

CASE WHEN {{ clicks }} = 0 THEN 0 ELSE ROUND({{ spend }} / {{ clicks }}, 2) END

CASE WHEN {{ clicks }} = 0 THEN 0 ELSE ROUND(CAST({{ spend }} AS BIGNUMERIC) / {{ clicks }}, 2) END

CASE WHEN {{ clicks }} = 0 THEN 0 ELSE ROUND(CAST({{ spend }} AS DECIMAL(38, 10)) / {{ clicks }}, 2) END

CASE WHEN {{ clicks }} = 0 THEN 0 ELSE ROUND(CAST({{ spend }} AS DECIMAL(38, 10)) / {{ clicks }}, 2) END

CASE WHEN {{ clicks }} = 0 THEN 0 ELSE ROUND(CAST(CAST({{ spend }} AS NUMERIC) / {{ clicks }} AS NUMERIC), 2) END

CASE WHEN {{ clicks }} = 0 THEN 0 ELSE ROUND(CAST({{ spend }} AS DECIMAL(38, 10)) / {{ clicks }}, 2) END

CASE WHEN {{ clicks }} = 0 THEN 0 ELSE ROUND({{ spend }} / {{ clicks }}, 2) END

CASE WHEN {{ clicks }} = 0 THEN 0 ELSE ROUND({{ spend }} / {{ clicks }}, 2) END

CASE WHEN {{ conversions }} = 0 THEN 0 ELSE ROUND({{ spend }} / {{ conversions }}, 2) END

CASE WHEN {{ conversions }} = 0 THEN 0 ELSE ROUND(CAST({{ spend }} AS BIGNUMERIC) / {{ conversions }}, 2) END

CASE WHEN {{ conversions }} = 0 THEN 0 ELSE ROUND(CAST({{ spend }} AS DECIMAL(38, 10)) / {{ conversions }}, 2) END

CASE WHEN {{ conversions }} = 0 THEN 0 ELSE ROUND(CAST({{ spend }} AS DECIMAL(38, 10)) / {{ conversions }}, 2) END

CASE WHEN {{ conversions }} = 0 THEN 0 ELSE ROUND(CAST(CAST({{ spend }} AS NUMERIC) / {{ conversions }} AS NUMERIC), 2) END

CASE WHEN {{ conversions }} = 0 THEN 0 ELSE ROUND(CAST({{ spend }} AS DECIMAL(38, 10)) / {{ conversions }}, 2) END

CASE WHEN {{ conversions }} = 0 THEN 0 ELSE ROUND({{ spend }} / {{ conversions }}, 2) END

CASE WHEN {{ conversions }} = 0 THEN 0 ELSE ROUND({{ spend }} / {{ conversions }}, 2) END

CASE WHEN {{ spend }} = 0 THEN 0 ELSE ROUND({{ revenue }} / {{ spend }}, 2) END

CASE WHEN {{ spend }} = 0 THEN 0 ELSE ROUND(CAST({{ revenue }} AS BIGNUMERIC) / {{ spend }}, 2) END

CASE WHEN {{ spend }} = 0 THEN 0 ELSE ROUND(CAST({{ revenue }} AS DECIMAL(38, 10)) / {{ spend }}, 2) END

CASE WHEN {{ spend }} = 0 THEN 0 ELSE ROUND(CAST({{ revenue }} AS DECIMAL(38, 10)) / {{ spend }}, 2) END

CASE WHEN {{ spend }} = 0 THEN 0 ELSE ROUND(CAST(CAST({{ revenue }} AS NUMERIC) / {{ spend }} AS NUMERIC), 2) END

CASE WHEN {{ spend }} = 0 THEN 0 ELSE ROUND(CAST({{ revenue }} AS DECIMAL(38, 10)) / {{ spend }}, 2) END

CASE WHEN {{ spend }} = 0 THEN 0 ELSE ROUND({{ revenue }} / {{ spend }}, 2) END

CASE WHEN {{ spend }} = 0 THEN 0 ELSE ROUND({{ revenue }} / {{ spend }}, 2) END

{{ pageviews }} <= 1

{{ pageviews }} <= 1

{{ pageviews }} <= 1

{{ pageviews }} <= 1

{{ pageviews }} <= 1

{{ pageviews }} <= 1

{{ pageviews }} <= 1

{{ pageviews }} <= 1

ROUND({{ seconds }} / 60, 1)

ROUND(CAST({{ seconds }} AS BIGNUMERIC) / 60, 1)

ROUND(CAST({{ seconds }} AS DECIMAL(38, 10)) / 60, 1)

ROUND(CAST({{ seconds }} AS DECIMAL(38, 10)) / 60, 1)

ROUND(CAST(CAST({{ seconds }} AS NUMERIC) / 60 AS NUMERIC), 1)

ROUND(CAST({{ seconds }} AS DECIMAL(38, 10)) / 60, 1)

ROUND({{ seconds }} / 60, 1)

ROUND({{ seconds }} / 60, 1)