with tab1 as (
SELECT
PLAYER,
avg(price) as avg_price,
median(price) as median_price,
count(*) as sales_events,
sum(price)
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'
GROUP BY 1
)
SELECT
(median(median_price)/max(median_price)) * 100
FROM tab1