Updated 2022-10-02
    with earning as (select day::DATE as DATEe,
    sum (LIQUIDITY_FEES) as "LIQUIDITY FEES",
    sum (BLOCK_REWARDS) as "BLOCK REWARDS",
    "BLOCK REWARDS" - "LIQUIDITY FEES" as "Fee volume need to offset",
    "BLOCK REWARDS" / "LIQUIDITY FEES" as Ratio
    from flipside_prod_db.thorchain.daily_earnings where day >= '2022-01-01' and LIQUIDITY_FEES > 0 group by DATEe),

    swaps as ( select date_trunc('day',block_timestamp) as DATE,
    COUNT (TX_ID) as swaps , sum (LIQ_FEE_RUNE) as Fee
    from flipside_prod_db.thorchain.swaps
    where DATE >= '2022-01-01' and LIQ_FEE_RUNE > 0 group by DATE)

    select sum(swaps) as Total_Swap,sum (Fee) as Total_Fee,sum ("BLOCK REWARDS") as Total_Rewards,sum ("Fee volume need to offset") as Total_Fee_needed,
    Total_Rewards/Total_Fee as Total_ratio,
    Total_Swap * Total_ratio as "Swap volume need to offset",
    Total_Fee / Total_Swap as Fee_Per_Swap,
    Total_Rewards / Fee_Per_Swap as "Ideal Number of Swaps",
    Total_Fee * Total_ratio as "equal_Fee"

    from swaps JOIN earning on swaps.DATE= earning.DATEe
    Run a query to Download Data