Delamir-6014Number of node addresses bonded by unique Node operators
    Updated 2022-09-20
    with operator as (select
    distinct(FROM_ADDRESS) as node_operator,
    count(split_part(memo,':',2)) as node_numbers
    from flipside_prod_db.thorchain.bond_events
    where BOND_TYPE = 'bond_paid'
    group by 1)
    select
    node_operator,
    node_numbers
    from operator
    where node_numbers > 6
    order by 2 desc

    Run a query to Download Data