exchange_rates AS()

in super-mode-calculator/src/lib/build-query.ts [24:30]

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

exchange_rates AS (
	SELECT target AS from_currency,(SELECT FIRST_VALUE(rate) OVER (PARTITION BY target ORDER BY rate ASC) AS eur_to_gbp_rate
	FROM datatech-platform-prod.datalake.fixer_exchange_rates
	WHERE target = 'GBP' AND date = '${format(
		dateForCurrencyConversionTable,
		'yyyy-MM-dd',
	)}') * (1/rate) AS to_gbp_rate