AephiaMy scanning test
Updated 2024-12-13
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH scanning_fleets AS (
SELECT
player_profile
,scanning_fleets
FROM $query('3a8ebe5d-26a2-455a-a891-95f51d6728e5')
WHERE player_profile = '{{player_profile}}'
)
,token_prices AS (
SELECT
DATE
,atlas_price
,sol_price
FROM $query('21b1f230-5365-41ed-9d66-3f14153bec8b')
)
,sage_volumes AS (
select
*
from $query('7c3f86ae-eb25-4134-b436-fa24aa0e0c9b')
)
,sage_prices AS (
SELECT
x.date,
zeroifnull(y.SDU_atlas) / nullifzero(y.SDU) as SDU_price,
zeroifnull(y.FUEL_atlas) / nullifzero(y.FUEL) as FUEL_price,
zeroifnull(y.FOOD_atlas) / nullifzero(y.FOOD) as FOOD_price,
--------------------------
x.atlas_price as atlas_price,
x.sol_price as sol_price
QueryRunArchived: QueryRun has been archived