select s.*, m.project_name

from solana.core.fact_nft_sales s

inner join solana.core.dim_nft_metadata m on m.mint=s.mint),

nft_mint_data as

select s.*, m.project_name

from solana.core.fact_nft_mints s

inner join solana.core.dim_nft_metadata m on m.mint=s.mint)

select 'opensea' as marketplace, 'number_of_projects_sold' as a, count(distinct NFT_ADDRESS ) as number_of_projects_sold from ethereum.core.ez_nft_sales

where block_timestamp>={{start_date}}

union

select 'opensea' as marketplace,'number_of_new_projects' as a, count(distinct nft_address) as number_of_new_projects from ethereum.core.ez_nft_mints

where block_timestamp>={{start_date}}

union

select 'quix' as marketplace,'number_of_projects_sold' as a, count(distinct NFT_ADDRESS ) as number_of_projects_sold from optimism.core.ez_nft_sales

where block_timestamp>={{start_date}}

select 'magic_eden' as marketplace,'number_of_projects_sold' as a, count(distinct project_name ) as number_of_projects_sold from nft_sale_data

where block_timestamp>={{start_date}}

union

select 'magic_eden' as marketplace, 'number_of_new_projects' as a, count(distinct project_name) as number_of_new_projects from nft_mint_data

where block_timestamp>={{start_date}}