--(Total Games Overtime)
WITH Contract_address AS( SELECT address FROM optimism.core.dim_contracts ) SELECT COUNT(DISTINCT CONTRACT_ADDRESS) AS ToOOtal_Games FROM
optimism.core.fact_event_logs WHERE CONTRACT_ADDRESS not in (SELECT address FROM Contract_address) AND EVENT_INPUTS:
from = '0x170a5714112daeff20e798b6e92e25b86ea603c1' AND TX_STATUS='SUCCESS' AND ORIGIN_TO_ADDRESS = '0x170a5714112daeff20e798b6e92e25b86ea603c1'
--0x170a5714112daeff20e798b6e92e25b86ea603c1' AND TX_STATUS='SUCCESS' AND ORIGIN_TO_ADDRESS = '0x170a5714112daeff20e798b6e92e25b86ea603c1'