count(distinct project_name) as total_projects_on_nftx

from

ethereum.core.ez_nft_sales

where

platform_name = 'nftx'

and project_name is not null

and event_type = 'redeem'