WHEN '0xae32496491b53841efb51829d6f886387708f99b' THEN '1.1.0'

WHEN '0x34cfac646f301356faa8b21e94227e3583fe3f5f' THEN '1.1.1'

WHEN '0x6851d6fdfafd08c0295c392436245e5bc78b0185' THEN '1.2.0'

WHEN '0xd9db270c1b5e3bd161e8c8503c55ceabee709552' THEN '1.3.0'

WHEN '0x3e5c63644e683549055b9be8653de26e0b4cd36e' THEN '1.3.1'

END AS METHOD,

COUNT(*) AS TX FROM ethereum.core.fact_traces

WHERE TO_ADDRESS IN (

'0xae32496491b53841efb51829d6f886387708f99b',

'0x34cfac646f301356faa8b21e94227e3583fe3f5f',

'0x6851d6fdfafd08c0295c392436245e5bc78b0185',

'0xd9db270c1b5e3bd161e8c8503c55ceabee709552',

'0x3e5c63644e683549055b9be8653de26e0b4cd36e'

)

AND SUBSTR(INPUT, 0, 10) = '0x6a761202'

AND TYPE = 'DELEGATECALL'

AND TX_STATUS = 'SUCCESS'

AND BLOCK_TIMESTAMP::DATE >= '2021-03-01'

GROUP BY METHOD