Query editor
WITH combined AS (SELECT project, volume_USDFROM query_7967107UNION ALLSELECT project, volume_USDFROM query_7928226UNION ALLSELECT project, volume_USDFROM query_6854413)SELECTCOUNT(*) AS total_tx_count,SUM(volume_USD) AS total_volume_USD,COUNT(DISTINCT project) AS total_unique_projectsFROM combined;