SELECT fo.PUBKEY_SCRIPT_ADDRESS, COUNT(ft.TX_ID) AS NoOfTransactions
FROM bitcoin.core.fact_outputs fo
LEFT JOIN bitcoin.core.fact_transactions ft ON fo.TX_ID = ft.TX_ID
WHERE fo.PUBKEY_SCRIPT_ADDRESS <> ''
GROUP BY fo.PUBKEY_SCRIPT_ADDRESS
ORDER BY NoOfTransactions DESC
LIMIT 10;