jackguyroun3-2 1
Updated 2022-09-26
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT
-- DISTINCT play_type
MOMENT_TIER,
avg(price),
count(*) as sales
FROM flow.core.ez_nft_sales
LEFT outer JOIN flow.core.dim_allday_metadata
ON flow.core.dim_allday_metadata.nft_id = flow.core.ez_nft_sales.nft_id
WHERE flow.core.ez_nft_sales.nft_collection LIKE '%AllDay'
AND play_type LIKE '{{ play_type }}'
GROUP BY 1
Run a query to Download Data