rajsUntitled Query
    Updated 2022-11-15
    SELECT
    -- *
    count(*),
    count(gas),
    sum(gas)
    from
    (
    SELECT
    -- substr()
    -- position('FlowFees.FeesDeducted"},"fields":["') in transaction_result,
    -- position('","1.00000000') in transaction_result,
    -- transaction_result:events[2]:value:fields[0],
    -- *
    case when transaction_result:events[0] ilike '%FeesDeducted%' then transaction_result:events[0]:value:fields[0]
    when transaction_result:events[1] ilike '%FeesDeducted%' then transaction_result:events[1]:value:fields[0]
    when transaction_result:events[2] ilike '%FeesDeducted%' then transaction_result:events[2]:value:fields[0]
    when transaction_result:events[3] ilike '%FeesDeducted%' then transaction_result:events[3]:value:fields[0]
    when transaction_result:events[4] ilike '%FeesDeducted%' then transaction_result:events[4]:value:fields[0]
    when transaction_result:events[5] ilike '%FeesDeducted%' then transaction_result:events[5]:value:fields[0]
    when transaction_result:events[6] ilike '%FeesDeducted%' then transaction_result:events[6]:value:fields[0]
    when transaction_result:events[7] ilike '%FeesDeducted%' then transaction_result:events[7]:value:fields[0]
    when transaction_result:events[8] ilike '%FeesDeducted%' then transaction_result:events[8]:value:fields[0]
    when transaction_result:events[9] ilike '%FeesDeducted%' then transaction_result:events[9]:value:fields[0]
    when transaction_result:events[10] ilike '%FeesDeducted%' then transaction_result:events[10]:value:fields[0]
    when transaction_result:events[11] ilike '%FeesDeducted%' then transaction_result:events[11]:value:fields[0]
    when transaction_result:events[12] ilike '%FeesDeducted%' then transaction_result:events[12]:value:fields[0]
    when transaction_result:events[13] ilike '%FeesDeducted%' then transaction_result:events[13]:value:fields[0]
    when transaction_result:events[14] ilike '%FeesDeducted%' then transaction_result:events[14]:value:fields[0]
    when transaction_result:events[15] ilike '%FeesDeducted%' then transaction_result:events[15]:value:fields[0]
    when transaction_result:events[16] ilike '%FeesDeducted%' then transaction_result:events[16]:value:fields[0]
    when transaction_result:events[17] ilike '%FeesDeducted%' then transaction_result:events[17]:value:fields[0]
    when transaction_result:events[18] ilike '%FeesDeducted%' then transaction_result:events[18]:value:fields[0]
    when transaction_result:events[19] ilike '%FeesDeducted%' then transaction_result:events[19]:value:fields[0]
    when transaction_result:events[20] ilike '%FeesDeducted%' then transaction_result:events[20]:value:fields[0]
    when transaction_result:events[21] ilike '%FeesDeducted%' then transaction_result:events[21]:value:fields[0]
    when transaction_result:events[22] ilike '%FeesDeducted%' then transaction_result:events[22]:value:fields[0]
    Run a query to Download Data