block_timestamp,

purchaser,

Seller,

mint,

sales_amount,

succeeded,

rank() over(partition by mint order by block_timestamp) as nft_sub_id

from solana.core.fact_nft_sales

where Seller='CMNyyCXkAQ5cfFS2zQEg6YPzd8fpHvMFbbbmUfjoPp1s'

and mint='4AT5bFKmouv216UyaMLqW5tmnTGQbJhUBSvXqDWPM55T'

and succeeded