-- Payout 22.73 SUSHI -- Grand Prize 68.19 SUSHI -- Level Intermediate -- Question 46: What percentage of xSushi holders have bought some xSushi from the secondary market (exchange) rather than turning to the sushi bar. -- Do you see a pattern? Can we tell anything about the profile of these addresses? with xsushi_holders as ( select distinct user_address as address from ethereum.erc20_balances where contract_address = '0x8798249c2e607446efb7ad49ec89dd1865ff4272' --xSUSHI and balance_date::date = CURRENT_DATE - 1 ), buy_xsushi_txns as ( select l.project_name, l.label_subtype, l.label_type, e.* from ethereum.dex_swaps e join crosschain.address_labels l on (e.from_address = l.address) where token_address = '0x8798249c2e607446efb7ad49ec89dd1865ff4272' -- xSUSHI -- and block_timestamp >= CURRENT_DATE - 90 and (l.label_type = 'dex' or l.label_type = 'cex') and direction = 'OUT' ), buy_wallets as ( select distinct to_address as wallet from buy_xsushi_txns where to_address in (select address from xsushi_holders) ), balances as ( select user_address as wallet, balance from ethereum.erc20_balances where balance_date = CURRENT_DATE - 1 and user_address in (select wallet from buy_wallets) and contract_address = '0x8798249c2e607446efb7ad49ec89dd1865ff4272' -- xSUSHI ) select count(distinct wallet) as n_wallets, CASE WHEN balance > 0 and balance <= 1 THEN 'a.0-1' WHEN balance > 1 and balance <= 10 THEN 'b.1-10' WHEN balance > 10 and balance <= 50 THEN 'c.10-50' WHEN balance > 50 and balance <= 1e2 THEN 'd.50-100' WHEN balance > 1e2 and balance <= 1e3 THEN 'e.100-1000' WHEN balance > 1e3 and balance <= 1e4 THEN 'f.1K-10K' WHEN balance > 1e4 and balance <= 1e5 THEN 'g.10K-100K' WHEN balance > 1e5 and balance <= 1e6 THEN 'h.100K-1M' WHEN balance > 1e6 and balance <= 1e7 THEN 'i.1M-10M' WHEN balance > 1e7 and balance <= 1e8 THEN 'j.10M-100M' WHEN balance > 1e8 THEN 'k.> 100M' END as category from balances group by category order by category

46.Sushi-Sushibar vs. Secondary Market