ramishoowUntitled Query
    Updated 2022-12-15
    select sum (amount) as "delegated", avg (amount) as "avrage User", median (amount) as MEDIAN, count (distinct tx_id) as "Transactions", count (distinct DELEGATOR_ADDRESS) as "Users",
    case when action in ('Delegate') then 'Delegate' end as ACTION, min (amount) as MIN, max (amount) as "Max Luna delegated " from terra.core.ez_staking
    --case when action in ('Delegate') then 'Delegate' end as ACTION, min (amount) as MIN, max (amount) as "Max Luna delegated " from terra.core.ez_staking
    --terra
    where tx_succeeded = 'TRUE' AND ACTION IS NOT NULL group by ACTION

    Run a query to Download Data