Hessishcosmo - val share
    Updated 2023-02-20
    with cos as (select count(DISTINCT ADDRESS) as val0
    from cosmos.core.fact_validators),

    osm as (select count(DISTINCT a.ADDRESS) as val1
    from cosmos.core.fact_validators a join osmosis.core.fact_validators b on a.LABEL=b.LABEL)

    select (val1*100/val0), val1, val0
    from cos,osm
    Run a query to Download Data