Query editor
SELECTcount (distinct front) as applicationsFROM(SELECTcoalesce(cast(frontend as varchar), cast(affiliate as varchar)) as front,sum(amount) as volumeFROM query_2832316LEFT JOIN dune.azuro.dataset_frontends USING(affiliate)GROUP BY 1HAVING sum(amount) > 1000)_