where ADDRESS_NAME ='lily'),

addressesss1 as (select DISTINCT address from solana.core.dim_labels

where ADDRESS_NAME ='degods'),

df_sales as (select

date_trunc('day', BLOCK_TIMESTAMP) as date, count(TX_ID) as TX_ID, sum(SALES_AMOUNT) as SALES_AMOUNT

from solana.core.fact_nft_sales

where SUCCEEDED = 'TRUE' and date >= '2022-11-18' and date <= '2022-12-10' and mint in (select address from addressesss)

group by 1),

df_sales2 as (select

date_trunc('day', BLOCK_TIMESTAMP) as date, count(TX_ID) as TX_ID, sum(SALES_AMOUNT) as SALES_AMOUNT

from solana.core.fact_nft_sales

where SUCCEEDED = 'TRUE' and date >= '2021-10-08' and date <= '2022-11-06' and mint in (select address from addressesss1)

group by 1)

select RANK() OVER (ORDER BY DATE asc) AS DAY_NUMBER, 'Lily' as Collection, count('TX_ID') as tx_count,

sum(SALES_AMOUNT) as amount,

sum (amount) over (order by DAY_NUMBER) as "Cumualtive amount",

sum (tx_count) over (order by DAY_NUMBER) as "Cumualtive # sales"

from df_sales group by 1,2

UNION ALL

select RANK() OVER (ORDER BY DATE asc) AS DAY_NUMBER, 'DeGods' as Collection, count('TX_ID') as tx_count,

sum(SALES_AMOUNT) as amount,

sum (amount) over (order by DAY_NUMBER) as "Cumualtive amount",

sum (tx_count) over (order by DAY_NUMBER) as "Cumualtive # sales"

from df_sales2 group by 1,2