count(case when t.succeeded = True then 1 else null end) as N_succeed_trx, -- Number of seccess swap

count(t.succeeded) as N_trx, -- Total Number of Transactions

N_succeed_trx/N_trx as Swap_Succeed_Rate -- Succeed Rate

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 '%jupiter%'

group by date