acquisitions_agg AS()

in bandit/src/query-lambda/build-query.ts [108:112]

• 5 lines of code
• 1 McCabe index (conditional complexity)

acquisitions_agg AS (
  SELECT
    test_name,
    variant_name,
    SUM(IF( av_gbp >= ${ANNUALISED_VALUE_CAP}, ${ANNUALISED_VALUE_CAP},  av_gbp)) sum_av_gbp,