select
project_name,
sum(price_usd) as sales,
count(token_id) as token_sales_this_week
from ethereum.nft_events
where event_type = 'sale'
and block_timestamp > current_date - 7
and event_platform = 'opensea'
and project_name IS NOT NULL
and project_name NOT IN ('opensea','ens')
group by 1
order by 3 desc;