select swap_to_mint as swapped_to_coin, count(s.tx_id) as number_of_swaps

from solana.swaps s

join solana.transactions t

on s.tx_id = t.tx_id

where swap_from_mint = 'So11111111111111111111111111111111111111112'

and swap_to_mint <> 'So11111111111111111111111111111111111111112'

and s.block_timestamp::date >= '2022-01-01'

and swap_program like '%orca%'

and t.succeeded = true

group by swapped_to_coin

order by number_of_swaps desc)

SELECT sl.label as labels, swaps.number_of_swaps as Numbers

from swaps

join solana.labels sl on sl.address = swaps.swapped_to_coin

order by Numbers desc

limit 5