count(DISTINCT SPLIT(payload_function, '::')[0]) AS no_contract,

count(DISTINCT payload_function)

FROM

aptos.core.fact_transactions

WHERE

tx_type = 'user_transaction'