sum(msg_value:execute_msg:claim:amount) / pow(10, 6) as total_genesis_anc_claimed

from terra.msgs

where msg_value:contract = 'terra146ahqn6d3qgdvmj8cj96hh03dzmeedhsf0kxqm'

and msg_value:execute_msg:claim is not null

and msg_value:execute_msg:claim:stage = 1

and tx_status = 'SUCCEEDED';