with datas as (
select MINT as token_id_contract ,TOKEN_ID , TOKEN_METADATA
from
solana.core.dim_nft_metadata
where (CONTRACT_NAME) ilike '%Degods%'
)
(select
PURCHASER as minter ,
MINT_PRICE ,
fv.tx_id ,
TOKEN_ID ,
TOKEN_METADATA,
fv.SUCCEEDED
from
solana.core.fact_nft_mints as fv inner join datas on token_id_contract = MINT )
select