supporter_plus_or_tier_three__twice AS()

in src/lib/bigquery.ts [83:90]

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

        supporter_plus_or_tier_three__twice AS (
            SELECT SUM(first_payment_unit_price_transaction_currency)*2 AS amount
            FROM reader_revenue.fact_holding_acquisition
            WHERE acquired_date >= '${
							config.StartDate
						}' AND acquired_date < DATE_SUB('${
		config.EndDate
	}', INTERVAL 1 MONTH)