DATE_TRUNC('month', BLOCK_TIMESTAMP) AS Month,

COALESCE(SUM(CASE WHEN LOWER(MARKETPLACE) = 'yawww' THEN 1 ELSE 0 END), 0) AS yawww,

COALESCE(SUM(CASE WHEN LOWER(MARKETPLACE) = 'solanart' THEN 1 ELSE 0 END), 0) AS solanart,

COALESCE(SUM(CASE WHEN LOWER(MARKETPLACE) = 'solport' THEN 1 ELSE 0 END), 0) AS solport,

COALESCE(SUM(CASE WHEN LOWER(MARKETPLACE) IN ('coral cube', 'Coral Cube') THEN 1 ELSE 0 END), 0) AS coral_cube,

COALESCE(SUM(CASE WHEN LOWER(MARKETPLACE) IN ('magic eden', 'magic eden v1', 'magic eden v2') THEN 1 ELSE 0 END), 0) AS magic_eden,

COALESCE(SUM(CASE WHEN LOWER(MARKETPLACE) = 'hadeswap' THEN 1 ELSE 0 END), 0) AS hadeswap,

COALESCE(SUM(CASE WHEN LOWER(MARKETPLACE) = 'exchange art' THEN 1 ELSE 0 END), 0) AS exchange_art,

COALESCE(SUM(CASE WHEN LOWER(MARKETPLACE) = 'tensorswap' THEN 1 ELSE 0 END), 0) AS tensorswap,

COALESCE(SUM(CASE WHEN LOWER(MARKETPLACE) = 'hyperspace' THEN 1 ELSE 0 END), 0) AS hyperspace,

COALESCE(SUM(CASE WHEN LOWER(MARKETPLACE) = 'opensea' THEN 1 ELSE 0 END), 0) AS opensea,

COALESCE(SUM(CASE WHEN LOWER(MARKETPLACE) = 'solana monkey business marketplace' THEN 1 ELSE 0 END), 0) AS solana_monkey_business_marketplace

solana.core.fact_nft_sales

GROUP BY

Month

ORDER BY

Month;