Updated 2024-08-02
    SELECT
    validator_type,
    COUNT(DISTINCT node_id) AS total_validators,
    SUM(COUNT(DISTINCT node_id)) OVER () AS sum_total_validators
    FROM
    flow.gov.dim_validator_labels
    WHERE
    project_name = 'flow validator'
    GROUP BY
    1
    ORDER BY
    2 DESC;

    QueryRunArchived: QueryRun has been archived