with degod_collection as ( select project_name , mint, case when token_metadata:Clothes in ('God Jersey','Gym Tee','World Champion Robe', 'FTX Jersey','God Scout Uniform') then 'Sports'

else 'Non-Sports' end as type

from solana.core.dim_nft_metadata

where PROJECT_NAME = 'DeGods')

,

degens_collection as ( select project_name , mint , case when token_metadata:Clothing in ('NB-Ape Green','NB-Ape Red','NB-Ape Yellow','Bowling Shir') then 'Sports'

else 'Non-Sports' end as type

from solana.core.dim_nft_metadata

where PROJECT_NAME = 'Degen Apes')

,

catalina_collection as ( select project_name , mint , case when token_metadata:Clothing in ('Fishing Waders','Stadium','Beast Mode','Chokehold','Freak','Goat','Golf','La Pulga Kit','Mamba') then 'Sports'

else 'Non-Sports' end as type

from solana.core.dim_nft_metadata

where PROJECT_NAME = 'Catalina Whale Mixer')

,

price as ( select date(block_timestamp) as p_date, (sum(SWAP_TO_AMOUNT)/sum(SWAP_FROM_AMOUNT)) as price

from solana.core.fact_swaps

where SWAP_FROM_MINT = 'So11111111111111111111111111111111111111112'

and SWAP_TO_MINT = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'

and p_date >= CURRENT_DATE - 90

group by 1)

,

degod as ( select date(block_timestamp) as date, type, project_name, tx_id, purchaser,seller, sales_amount, sales_amount*price as volume

from Solana.core.fact_nft_sales a join degod_collection b on a.mint = b.mint

left outer join price c on a.block_timestamp::date = c.p_date

where date >= CURRENT_DATE - 90)

,

degen as ( select date(block_timestamp) as date, type, project_name, tx_id, purchaser,seller, sales_amount, sales_amount*price as volume

from Solana.core.fact_nft_sales a join degens_collection b on a.mint = b.mint

left outer join price c on a.block_timestamp::date = c.p_date

where date >= CURRENT_DATE - 90)

,

catalina as ( select date(block_timestamp) as date, type, project_name, tx_id, purchaser,seller, sales_amount, sales_amount*price as volume

from Solana.core.fact_nft_sales a join catalina_collection b on a.mint = b.mint