with profile_create_list as (
select
signer_id,
block_timestamp,
profile_section
from near.social.fact_profile_changes
join near.core.fact_transactions using(tx_hash)
where tx_status = 'Success'
)
select
count(distinct signer_id) as "Total Number of Profiles Creations"
from profile_create_list