headitmanagerMost Popular Jupiter Swaps - part2
    Updated 2022-03-08
    with top10popular as (Select SWAP_TO_MINT as swap_for,
    count(*) as swapcount
    From Solana.swaps s LEFT OUTER JOIN Solana.labels b
    ON s.swap_program=b.label
    Where block_timestamp::date >= '2022-02-01'
    And succeeded = 'True' and swap_program='jupiter aggregator v2'
    Group by swap_for
    order by swapcount DESC
    limit 10)
    ,
    tbl_popular as (select max(swapcount) as mostpopular from top10popular)
    select case
    when swap_for = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then 'USD Coin'
    when swap_for = 'So11111111111111111111111111111111111111112' then 'Wrapped SOL'
    when swap_for = '4k3Dyjzvzp8eMZWUXbBCjEvwSkkk59S5iCNLY3QrkX6R' then 'Token Raydium'
    when swap_for = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' then 'USDT'
    when swap_for = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So' then 'Marinade staked SOL (mSOL)'
    when swap_for = 'StepAscQoEioFxxWGnh2sLBDFp9d8rvKz2Yp39iDpyT' then 'Step'
    when swap_for = '9n4nbM75f5Ui33ZbPYXn59EwSgE8CGsHtAeTH5YFeJ9E' then 'Wrapped Bitcoin (Sollet)'
    when swap_for = 'SUNNYWgPQmFxe9wTZzNK7iPnJ3vYDrkgnxJRJm1s3ag' then 'Sunny Governance Token'
    when swap_for = 'DubwWZNWiNGMMeeQHPnMATNj77YZPZSAz2WVR5WjLJqz' then 'CropperFinance'
    when swap_for = '9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i' then 'UST (Wormhole)'
    when swap_for = 'AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB' then 'GST'
    when swap_for = '7vfCXTUXx5WJV5JADk17DUJ4ksgau7utNKj4b963voxs' then 'Ether (Wormhole)'
    when swap_for = 'orcaEKTdK7LKz57vaAYr9QeNsVEPfiu6QeMU1kektZE' then 'ORCA'
    when swap_for = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' then 'ATLAS'
    end as tokenname,
    swapcount,
    case when swapcount = (select mostpopular from tbl_popular) then 'most popular'
    else 'popular' end as popular from top10popular