acquisitions_agg AS()

in super-mode-calculator/src/lib/build-query.ts [102:108]

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

acquisitions_agg AS (
	SELECT region, referrer_url, SUM(av_gbp) sum_av_gbp, COUNT(*) acquisitions
	FROM acquisitions_with_av_gbp
	GROUP BY 1, 2
	),
views_with_regions AS (
		SELECT *,  ${regionSql('country_key')}