select date_trunc('month',block_timestamp) as block_month,

event, block_id,

event_attributes:missed_blocks as miss_block,

event_attributes:address::string as address,

label,

case when label is null then 'unknown' else label end as validator

from terra.transitions a

left join terra.labels b ON a.event_attributes:address = b.address

where event = 'liveness'

and block_timestamp >= '2021-03-01'

order by 1 DESC

select block_month, validator, count(event) as offline_count

from transition

where miss_block = 300

group by 1,2