jackguylol_500
    Updated 2022-09-26
    SELECT
    avg(price),
    median(price),
    count(*) as sales,
    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'
    AND team LIKE '{{team}}'
    Run a query to Download Data