-- What is DAI most used for?
SELECT
EVENT_NAME ,
COUNT(*) as number
FROM
flipside_prod_db.ethereum_core.fact_event_logs
WHERE
CONTRACT_ADDRESS
IN
(
SELECT
CONTRACT_ADDRESS
FROM
flipside_prod_db.ethereum_core.ez_token_transfers
WHERE
SYMBOL = 'DAI'
)
AND EVENT_NAME IS NOT NULL
GROUP BY EVENT_NAME
ORDER BY number DESC