acqusitions_with_av_gbp AS()

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

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

acqusitions_with_av_gbp AS(
  SELECT
	acq_av.*,
	CASE acq_av.currency
		WHEN 'GBP' THEN av_eur
		ELSE av_eur * (gbp_rate.rate)
		END
	AS av_gbp
	FROM acqusitions_with_av AS acq_av
	JOIN  gbp_rate  ON acq_av.date = gbp_rate.date
	),
acquisitions_agg AS (
  SELECT
    test_name,
    variant_name,
    SUM(IF( av_gbp >= ${ANNUALISED_VALUE_CAP}, ${ANNUALISED_VALUE_CAP},  av_gbp)) sum_av_gbp,