SELECT

TX_HASH

from ethereum.core.fact_event_logs

where contract_address='0x5d2c31ce16924c2a71d317e5bbfd5ce387854039'

and EVENT_INPUTS IS NOT NULL

and EVENT_NAME='VoteCast'

and tx_status='SUCCESS'

ORDER BY

BLOCK_TIMESTAMP DESC

SELECT AVG(TX_FEE)

FROM vote_data, ethereum.core.fact_transactions AS gas_data

WHERE vote_data.TX_HASH = gas_data.TX_HASH