Query editor
WITH w AS (SELECT week, uln_ver,SUM(msgs) AS msgs,SUM(CASE WHEN state = 'Success' THEN msgs ELSE 0 END) AS msgs_success,ROUND(SUM(usd_transfers), 2) AS usd,SUM(CASE WHEN in_canary_list = 1 THEN msgs ELSE 0 END) AS canary_list_msgsFROM query_8916066GROUP BY 1, 2)SELECT w.*,(SELECT CAST(MAX(ts_source) AS varchar) FROM layerzero.messages WHERE ts_source >= now() - INTERVAL '3' DAY) AS lz_messages_max_ts_source,(SELECT CAST(MAX(block_date) AS varchar) FROM dune.canaryprotocol.result_transaction_list_validated_by_lz_canary_dvn) AS canary_list_max_block_dateFROM wORDER BY week, uln_ver