Вычисляемое значение поля

SELECT
  counterparty,
  agreement,
  now()::date-agreementdate::date AS time_remaining,
  round(100 * placed_in_production::integer/number_of_item::integer,1) AS percent,
  CASE
    WHEN
      now()::date-agreementdate::date <= 14
      AND
      round(100 * placed_in_production::integer/number_of_item::integer,1) < 50
    THEN 'Hight'
    WHEN
      now()::date-agreementdate::date <= 14
      AND
      round(100 * placed_in_production::integer/number_of_item::integer,1) >= 50
    THEN 'Medium'
    WHEN
      now()::date-agreementdate::date > 14
      AND
      round(100 * placed_in_production::integer/number_of_item::integer,1) >= 50
    THEN 'Low'
        WHEN
      now()::date-agreementdate::date > 14
      AND
      round(100 * placed_in_production::integer/number_of_item::integer,1) < 50
    THEN 'Hight'
    ELSE 'None'
  END
FROM commerce
WHERE counterparty = '${Customer}';