case

when PROPOSER_ADDRESS = 'CB5A63B91E8F4EE8DB935942CBE25724636479E0' then 'Cosmostation'

when PROPOSER_ADDRESS = '16A169951A878247DBE258FDDC71638F6606D156' then 'Sentinel dVPN'

when PROPOSER_ADDRESS = '9D0281786872D3BBE53C58FBECA118D86FA82177' then 'Figment'

when PROPOSER_ADDRESS = '76F706AE73A8251652BC72CB801E4294E2135AFB' then '0base.vc'

when PROPOSER_ADDRESS = '66B69666EBF776E7EBCBE197ABA466A712E27076' then 'Inotel'

when PROPOSER_ADDRESS = 'E08FBA0FE999707D1496BAAB743EAB27784DC1C5' then 'Chorus One'

when PROPOSER_ADDRESS = '6239A498C22DF3EC3FB0CA2F96D15535F6F3387A' then 'SG-1'

when PROPOSER_ADDRESS = '9E7CAE009EFFF4D163F3FB8781A07B25C2B10B32' then 'StakeLab'

when PROPOSER_ADDRESS = '844290531EE59B40FEEFDE5259857368BF7119EC' then 'wosmongton'

when PROPOSER_ADDRESS = '06F45C36FCB957E55D923A6D4E905C2D715115AD' then 'Provalidator'

end as Validator,

count(DISTINCT BLOCK_ID) as validated_blocks,

round(validated_blocks*100/(select count(DISTINCT block_id) from osmosis.core.fact_blocks),2) as "% of total blocks",

max(BLOCK_TIMESTAMP::datetime) as "Last block"

from osmosis.core.fact_blocks group by 1 order by 2 desc limit 10 offset 1

-- join osmosis.core.fact_validators on PROPOSER_ADDRESS = PROJECT_NAME