AephiaMy scanning_earnings
    Updated 2 days ago
    WITH scanning AS (
    SELECT
    date
    ,player_profile
    ,round(sum(sdu_found)) as sdu_found_pp
    ,round(sum(sdu_max)) as sdu_max_pp
    ,round(sum(food_burned)) as food_burned_pp
    ,round(sum(fuel_burned)) as fuel_burned_pp
    ,round(sum(scanning_txs)) as scanning_txs_pp
    ,round(sum(successful_scans)) as successful_scans_pp
    ,round(sum(sdu_missing_out)) as sdu_missing_out_pp
    ,round(sum(sol_payed),4) as sol_payed_pp

    from $query('c7d84fbe-8ecd-47da-9564-dce10ed11179')
    WHERE player_profile = '{{player_profile}}'
    group by 1,2

    )

    ,last_value AS (
    SELECT
    *
    from $query('6a2519e0-27f9-4633-8fe0-8934f60d6bb2')
    )

    ,sdu_calculations AS (
    SELECT
    x.date
    ,sdu_found_pp
    ,sdu_max_pp
    ,sdu_missing_out_pp
    ,sdu_price
    ,atlas_price
    Last run: 2 days ago
    No Data to Display
    0
    2B
    3s