with tab1 as (

select

SIGNERS

,TX_ID

from solana.core.fact_events

where PROGRAM_ID='pAMMTYk2C9tAxenepGk8a1bi9JQtUdnzu3UAh7NxYcW'),

tab2 as (

select

case

when TX_TO='AvtaKmiMxsSBFa24sR42hovykPyXyFDWqGzM8eHfqD9i' then 'Atlanta'

when TX_TO='5f2eQJwLhCvpKVc9BRfu6sQfqVhvYnsgEjxbTUuoWGar' then 'Chicago'

when TX_TO='HFkRy7pjHjvkH7CpX42qcXwx2kJtAxjQWziJ4TTc3GiC' then 'Denver'

when TX_TO='CAYRqwXJnfY6rvdEr5764Mzpx3PwNvh8kjidKYPkFwmq' then 'Phoenix'

when TX_TO='4KPrE7c5wnDgDdRTFiP1kk7Y2hYD9M53gsAvRv9SFAdT' then 'Philadelphia'

when TX_TO='3mE1oiFdLs8zntSk8bPLLY6Cq1vf5tbHpnyywunFysGZ' then 'Las Vegas'

when TX_TO='DX5q4ntVPFZTCezDZ399aa319Ex135scvKoPLLYHpyvH' then 'Boston'

when TX_TO='5hHfPfyvgqLUy7YKNifmkRLGR3TsEtkPePcD4fK3Cf3U' then 'Miami Beach'

when TX_TO='6vPhHq5dmxQ1TReVbP6KZLuZSWBTCZYD5xewgodiQtpr' then 'New York'

when TX_TO='9wddE1JLdpPkfZQ2rTCziCX5RTSuuK8UYXTqfv6XwpuS' then 'Portland'

when TX_TO='HRhMJ1Gf9UKFNPhfM9N3itS7NNwo42jVA4b4EH8oBjsK' then 'Seattle'

when TX_TO='AmH5fNSGyzbSqMFobKaw3cLdmwcMqn1xU8ZQ8vhimwu4' then 'Washington'

when TX_TO='FAkAaRUwGBXWcVXgKPm7tLrtKRumDKL85o2sc6GiJB2q' then 'Los Angeles'

when TX_TO='7Si7o3jSvTkd5XKfLAG1j5jJsVyf9xGF41VAfZ5J2WMH' then 'San Francisco'

when TX_TO='J7q1TjtQrRt6CjY7AxAoVXmtoqciwP68Eg2rndCrhgKs' then 'Austin'

when TX_TO='HHociD1dX72uHCJduArg7GwYLjwnJAhktB519TiWtEEA' then 'USA'

when TX_TO='AJdeDriASqCTdGyyHzmjjhTHhQNbYerjWgHvf69C1Cu3' then 'Paris'

when TX_TO='48s3N7YyRA4cDFCCfnWdouBqH1u8oWmkn5FGN9q4yV6z' then 'Ile-de-France'

when TX_TO='BGcueHkycD33uWqXmoo6HtCHoTRgBi3dhZFtbtu8wZsX' then 'San Francisco'

when TX_TO='Cdg736xbENeAiixbY2AzRCvefe1aKEWoi6sSyb3qKxAk' then 'Brooklyn'

when TX_TO='EzUHwP4QkWtVXy31czKj2KAdCW5ZayBjX91ZN36cEkDf' then 'Manhattan'

when TX_TO='12qXTAjwfXCfK4pPVxG9YP1UYJ1fuhucUoCRSyhtu3GS' then 'Los Angeles'

when TX_TO='DEFfvK3R54NW6sqKAxk1uY7qjgQ9pWvQeCx4PNfeZpAg' then 'Phoenix'

when TX_TO='5uK3SvUy93dneakP5PavYEr3SsCem7FKoTCtaemXuFHy' then 'Miami' end as loc

,AMOUNT

,TX_TO