Query editor
WITHcombined_daily_data AS (SELECT * FROM dune.okxweb3wallet.result_all_products_summary_part_2WHERE normalized_chain = 'ETH' and normalized_token_type = 'Meme'UNION ALLSELECT * FROM dune.okxweb3wallet.result_all_products_summary_part_1WHERE normalized_chain = 'ETH' and normalized_token_type = 'Meme'UNION ALLSELECT * FROM dune.okxweb3wallet.result_all_products_summary_part_3WHERE normalized_chain = 'ETH' and normalized_token_type = 'Meme'UNION ALLSELECT * FROM dune.okxweb3wallet.result_all_products_summary_part_4WHERE normalized_chain = 'ETH' and normalized_token_type = 'Meme'UNION ALLSELECT * FROM dune.okxweb3wallet.result_all_products_summary_part_5WHERE normalized_chain = 'ETH' and normalized_token_type = 'Meme'),-- 找出有 ETH 链数据的竞品products_with_eth AS (SELECT DISTINCT product_nameFROM combined_daily_data),-- 按日期和产品统计交易量daily_product_volumes AS (SELECTday,product_name,normalized_token_type,SUM(volume) as daily_volumeFROM combined_daily_dataJOIN products_with_eth USING (product_name)GROUP BY day, product_name, normalized_token_type)-- 最终结果SELECTday,product_name,normalized_token_type,daily_volumeFROM daily_product_volumesORDER BYday DESC,normalized_token_type,daily_volume DESC;