SELECT

a.tx_id,

CASE

WHEN b.log_messages::string ILIKE '%r 0 f%' THEN 'Zero Royalty' ELSE 'With Royalty' end AS zero_royalty

FROM solana.core.fact_nft_sales as a JOIN solana.core.fact_transactions as b on a.tx_id = b.tx_id

WHERE a.marketplace = 'solanart' and a.block_timestamp > CURRENT_DATE - 7

SELECT zero_royalty, COUNT(DISTINCT tx_id) as tx_count

FROM solanart

GROUP BY zero_royalty