-- forked from The distribution of NFTs among Holders @ https://flipsidecrypto.xyz/edit/queries/91d054fb-39b3-4feb-ae29-b95b2e9ee113 -- forked from The distribution of NFTs among Holders copy @ https://flipsidecrypto.xyz/edit/queries/755e63d2-679e-482b-9e85-9d9a8124e15c -- forked from BlockTracker / The distribution of NFTs among Holders @ https://flipsidecrypto.xyz/BlockTracker/q/y4WrGM1SlJIQ/the-distribution-of-nfts-among-holders with sales as (SELECT DISTINCT tx_id, block_timestamp FROM sei.core.fact_msg_attributes WHERE attribute_key = 'nft_address' and attribute_value = 'sei1g2a0q3tddzs7vf7lk45c2tgufsaqerxmsdr2cprth3mjtuqxm60qdmravc' AND MSG_TYPE = 'wasm-buy_now' ) , n_sellers as ( SELECT DISTINCT attribute_value as sellers, tx_id, block_timestamp FROM sei.core.fact_msg_attributes WHERE attribute_key = 'nft_seller' and tx_id in (SELECT tx_id FROM sales) ), n_buyers as ( SELECT DISTINCT attribute_value as buyers, tx_id, block_timestamp FROM sei.core.fact_msg_attributes WHERE attribute_key = 'fee_payer' and tx_id in (SELECT tx_id FROM sales) ) , nft as ( SELECT tx_id, ATTRIBUTE_VALUE as nft_id FROM sei.core.fact_msg_attributes WHERE tx_id IN (SELECT tx_id FROM sales) AND ATTRIBUTE_KEY = 'nft_token_id' ) , last_buyer as ( SELECT buyers, nft_id, ROW_NUMBER() over (PARTITION BY nft_id ORDER BY block_timestamp DESC) as transaction_rank FROM n_buyers a JOIN nft b using(tx_id) ) , mint as ( SELECT DISTINCT b.tx_id , b.block_timestamp FROM sei.core.fact_msg_attributes a , sei.core.fact_msg_attributes b WHERE a. tx_id = b.tx_id AND a.attribute_value = 'mint' and a.attribute_key = 'action' AND b.ATTRIBUTE_KEY = 'collection' AND b.ATTRIBUTE_VALUE = 'sei1g2a0q3tddzs7vf7lk45c2tgufsaqerxmsdr2cprth3mjtuqxm60qdmravc' ) , n_minter as ( SELECT DISTINCT ATTRIBUTE_VALUE as minter, tx_id, block_timestamp FROM sei.core.fact_msg_attributes WHERE tx_id IN (SELECT tx_id FROM mint) AND ATTRIBUTE_KEY = 'owner' ) , n_item as ( SELECT tx_id, ATTRIBUTE_VALUE as nft_id FROM sei.core.fact_msg_attributes WHERE tx_id IN (SELECT tx_id FROM mint) AND ATTRIBUTE_KEY = 'token_id' ) , holders as ( SELECT user, count(DISTINCT nft_id) as n_nft, CASE when n_nft = 1 then '1 NFT' when n_nft = 2 then '2 NFT' when n_nft = 3 then '3 NFT' when n_nft >3 AND n_nft <= 6 then '3< NFT <=6' when n_nft >6 AND n_nft <= 10 then '6< NFT <=10' when n_nft >10 AND n_nft <= 20 then '10< NFT <=20' when n_nft >20 AND n_nft <= 30 then '20< NFT <=30' when n_nft >30 AND n_nft <= 40 then '30< NFT <=40' when n_nft >40 AND n_nft <= 50 then '40< NFT <=50' when n_nft >50 AND n_nft <= 60 then '50< NFT <=60' when n_nft >60 AND n_nft <= 70 then '60< NFT <=70' when n_nft >70 AND n_nft <= 80 then '70< NFT <=80' when n_nft >80 AND n_nft <= 90 then '80< NFT <=90' when n_nft >90 AND n_nft <= 100 then '90< NFT <=100' else 'more than 100 NFT' end as type FROM ( SELECT minter as user, nft_id FROM n_minter LEFT JOIN n_item using(tx_id) WHERE nft_id NOT IN (SELECT nft_id FROM last_buyer) UNION SELECT buyers as user, nft_id FROM last_buyer WHERE transaction_rank = 1 ) GROUP BY 1 ) SELECT type, count(DISTINCT user) as n_users FROM holders GROUP BY 1

Seiyans are here