elsina99% of sales count is less than $1000
    Updated 2022-09-28
    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