date(a.block_timestamp) as date,

sum(case when a.marketplace in ('magic eden v2', 'magic eden v1') then sales_amount end) as magic_eden,

sum(case when a.marketplace in ('yawww') then sales_amount end) as yaww,

sum(case when a.marketplace in ('solanart') then (sales_amount) end) as solanart,

sum(case when a.marketplace in ('opensea') then (sales_amount) end) as opensea,

sum(case when a.marketplace in ('hadeswap') then (sales_amount) end) as hadeswap,

sum(case when a.marketplace not in ('magic eden v1', 'magic eden v2', 'solanart', 'yawww','opensea') then (sales_amount) end) as other,

'below are counts, above are sums',

count(case when a.marketplace in ('magic eden v2', 'magic eden v1') then sales_amount end) as magic_eden_count,

count(case when a.marketplace in ('yawww') then sales_amount end) as yaww_count,

count(case when a.marketplace in ('solanart') then (sales_amount) end) as solanart_count,

count(case when a.marketplace in ('opensea') then (sales_amount) end) as opensea_count,

count(case when a.marketplace in ('hadeswap') then (sales_amount) end) as hadeswap_count,

count(case when a.marketplace not in ('magic eden v1', 'magic eden v2', 'solanart', 'yawww','opensea') then (sales_amount) end) as other_count

from solana.core.fact_nft_sales a

group by 1

order by 1 desc