elsina99% of sales count is less than $1000
Updated 2022-09-28Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select
case
when moment_description ilike '%win%' or moment_description ilike '%victory%' or moment_description ilike '%lead%' or moment_description ilike '%prevail%' then 'win'
when moment_description ilike '%loss%' or moment_description ilike '%defeat%' or moment_description ilike '%fall%' or moment_description ilike '%lose%' or moment_description ilike '%fell%' or moment_description ilike '%beat%' then 'loss'
when moment_description ilike '%tie%' then 'tie'
end as result,
case when price <= 1000 then '<= $1000' else '> $1000' end as dis,
count(*) as number_of_sales
FROM
flow.core.dim_allday_metadata m left join flow.core.ez_nft_sales s on s.nft_id = m.nft_id
WHERE
tx_succeeded = TRUE and
moment_description != 'PLACEHOLDER'
group by 1, 2
Run a query to Download Data