shadilTop 10 matches with highest number of bettors (Soccer)
    Updated 2022-08-22
    with q1 as (select optimism.core.fact_event_logs.event_inputs:from as bettor,
    optimism.core.fact_event_logs.event_inputs:value/pow(10, case
    when optimism.core.fact_event_logs.contract_address ilike lower('0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9') then 18
    when optimism.core.fact_event_logs.contract_address ilike lower('0x7f5c764cbc14f9669b88837ca1490cca17c31607') then 6
    when optimism.core.fact_event_logs.contract_address ilike lower('0x94b008aa00579c1307b0ef2c499ad98a8ce58e58') then 6
    when optimism.core.fact_event_logs.contract_address ilike lower('0xda10009cbd5d07dd0cecc66161fc93d7c9000da1') then 18
    when optimism.core.fact_event_logs.contract_address ilike lower('0xc40f949f8a4e094d1b49a23ea9241d289b7b2819') then 18
    when optimism.core.fact_event_logs.contract_address ilike lower('0xcb8fa9a76b8e203d8c3797bf438d8fb81ea3326a') then 18
    when optimism.core.fact_event_logs.contract_address ilike lower('0x4200000000000000000000000000000000000006') then 18
    when optimism.core.fact_event_logs.contract_address ilike lower('0xe405de8f52ba7559f9df3c368500b6e6ae6cee49') then 18 end) as total,
    regexp_substr_all(substr(joined_table1.data, 3, len(joined_table1.data)),'.{64}')[1] as s1,
    concat('0x', substr(s1, 25, len(s1))) as ad
    from optimism.core.fact_event_logs join optimism.core.fact_event_logs joined_table1
    on joined_table1.tx_hash = optimism.core.fact_event_logs.tx_hash
    where optimism.core.fact_event_logs.origin_from_address = optimism.core.fact_event_logs.event_inputs:from
    and optimism.core.fact_event_logs.block_timestamp >= '2022-08-05' -- Since two weeks ago
    ),

    q2 as (
    SELECT q1.*, table1.match_name from q1
    join (select '0xd67c96fa2d3070085c5ee32104773ccc2dbd21ac' as match_address, 'FC Dallas FC | Inter Miami CF Inter Miami CF' as match_name
    from dual union
    select '0xd19a0d47f44393d238878bc49ce804bef3373647' as match_address, 'Colorado Rapids | Austin FC Austin FC' as match_name
    from dual union
    select '0x840747e4e00c3e012bd93a3cf0bf419a7a01535a' as match_address, 'Los Angeles Galaxy | CF Montréal Montréal' as match_name
    from dual union
    select '0xfc2392649624f561590d76147d07bd19fe14309a' as match_address, 'Philadelphia Union | DC United United' as match_name
    from dual union
    select '0x70121d2255d9f423e5d35462814657656f553110' as match_address, 'Chicago Fire | Columbus Crew' as match_name
    from dual union
    select '0x738a2f1f823656885cb61d18373b47f0f15236ec' as match_address, 'Orlando City SC | Inter Miami CF Inter Miami CF' as match_name
    from dual union
    select '0xa2a3e2f1753ca73898a6d7ae6e511d5f36b89f38' as match_address, 'Houston Dynamo | FC Dallas FC' as match_name
    from dual union
    select '0xb964b9b5c55efa0b7f52389283c4b42ba65e22c4' as match_address, 'Real Salt Lake | Colorado Rapids' as match_name
    from dual union
    Run a query to Download Data