Query editor
SELECTCASE WHEN function_name IS NULL THEN 'ETH Transfer'ELSE function_nameEND AS function_name,COUNT(DISTINCT tx_hash) AS trx,COUNT(*) AS recordsFROM query_3471550GROUP BY 1ORDER BY 2 DESC
Query editor
1SELECT2CASE WHEN function_name IS NULL THEN 'ETH Transfer'3ELSE function_name4END AS function_name,5COUNT(DISTINCT tx_hash) AS trx,6COUNT(*) AS records7FROM query_347155089GROUP BY 110ORDER BY 2 DESC