from solana.core.fact_nft_sales

inner join solana.core.dim_labels on

solana.core.fact_nft_sales.mint = solana.core.dim_labels.address

where solana.core.dim_labels.label = 'aurory'

and solana.core.dim_labels.label_subtype = 'nf_token_contract'

group by DATE

order by date desc