SELECT
ADDRESS_NAME,
COUNT (DISTINCT TX_ID) as app_used
FROM
solana.core.fact_events JOIN solana.core.dim_labels
ON solana.core.fact_events.PROGRAM_ID = solana.core.dim_labels.address
WHERE
BLOCK_TIMESTAMP::DATE >= '2022-06-01'
GROUP BY ADDRESS_NAME
ORDER BY app_used DESC