kasadeghAverage Daily Transactions Count Befor/In/After the NBA Conference Finals
    Updated 2022-07-10
    with TopShot_Sale_Info_Before_Conference_Finals as (

    select t1.block_timestamp::date as day,t1.TX_ID, t2.EVENT_CONTRACT as NFT_COLLECTION_NAME,t1.PRICE, t3.*
    from flow.core.fact_nft_sales t1
    join flow.core.dim_contract_labels t2
    on t1.NFT_COLLECTION=t2.EVENT_CONTRACT
    join flow.core.dim_topshot_metadata as t3
    on t3.NFT_ID=t1.NFT_ID
    where day >='2022-05-4' and day <= '2022-05-16'
    ),
    TopShot_Sale_Info_In_Conference_Finals as (

    select t1.block_timestamp::date as day,t1.TX_ID, t2.EVENT_CONTRACT as NFT_COLLECTION_NAME,t1.PRICE, t3.*
    from flow.core.fact_nft_sales t1
    join flow.core.dim_contract_labels t2
    on t1.NFT_COLLECTION=t2.EVENT_CONTRACT
    join flow.core.dim_topshot_metadata as t3
    on t3.NFT_ID=t1.NFT_ID
    where day >= '2022-05-17' and day<='2022-05-29'
    )
    ,
    TopShot_Sale_Info_After_Conference_Finals as (

    select t1.block_timestamp::date as day,t1.TX_ID, t2.EVENT_CONTRACT as NFT_COLLECTION_NAME,t1.PRICE, t3.*
    from flow.core.fact_nft_sales t1
    join flow.core.dim_contract_labels t2
    on t1.NFT_COLLECTION=t2.EVENT_CONTRACT
    join flow.core.dim_topshot_metadata as t3
    on t3.NFT_ID=t1.NFT_ID
    where day >= '2022-05-30' and day <='2022-06-12'
    )
    select 'Average Daily Transaction Count' as "Average Daily Transaction Count",
    (
    select avg(Total_Transaction_Count) as Average_Daily_Transaction_Counte_Befour_Conferance from
    Run a query to Download Data