SELECT COALESCE()

in src/lib/bigquery.ts [125:135]

• 11 lines of code
• 2 McCabe index (conditional complexity)

        SELECT COALESCE(SUM(amount), 0) AS amount FROM (
                    SELECT amount FROM contributions__once UNION ALL
                    SELECT amount FROM contributions__twice UNION ALL
                    SELECT amount FROM supporter_plus_or_tier_three__once UNION ALL
                    SELECT amount FROM supporter_plus_or_tier_three__twice  ${
											config.CountryCode === 'AU'
												? `UNION ALL
                    SELECT amount FROM iap_acquisitions__once UNION ALL
                    SELECT amount FROM iap_acquisitions__twice`
												: ''
										}