from terra.reward

where tx_status = 'SUCCEEDED' and currency is not null and action = 'withdraw_delegator_rewards' and date >= '2020-10-27'

group by 1,3),

label as (select operator_address, label

from terra.validator_labels)

select r.date, r.amount_usd, r.validator, l.label, case when l.label is null then r.validator else l.label end as validators

from rewards r

left join label l on r.validator = l.operator_address;