Query editor
SELECT 'v1_multichain' AS src, chain,COUNT(*) AS rows_90d, COUNT(amount) AS rows_with_amount,MIN(evt_block_time) AS first_evt, MAX(evt_block_time) AS last_evtFROM lifi_multichain.lifidiamond_evt_lifitransferstartedWHERE evt_block_time >= now() - INTERVAL '90' dayGROUP BY 1, 2UNION ALLSELECT 'v2_multichain' AS src, chain,COUNT(*) AS rows_90d, 0 AS rows_with_amount,MIN(evt_block_time) AS first_evt, MAX(evt_block_time) AS last_evtFROM lifi_multichain.lifidiamond_v2_evt_lifitransferstartedWHERE evt_block_time >= now() - INTERVAL '90' dayGROUP BY 1, 2ORDER BY rows_90d DESC