with A as (select distinct nft_collection as project
from flow.core.fact_nft_sales)
select project,
split_part(project,'.',3)
from A
'PackNFT'
'MFLPack'
'BleacherReport_NFT'
'Genies'
'MetaPanda'
'RCRDSHPNFT'
'AllDay'
'TopShot'
'TFCItems'
'CricketMoments'
'RaribleNFT'
'UFC_NFT'