select date_trunc( 'month',date) as month,case when PROTOCOL = 'LooksRare' then 'LooksRare'
when PROTOCOL = 'opensea' then 'Opensea'
else 'others' end as type_of_platform,
sum(fees) as total_fee_in_USD, sum(revenue) as total_revenue_in_USD
from external.defillama.fact_protocol_fees_revenue
where (PROTOCOL = 'LooksRare' or PROTOCOL = 'opensea')
and date >= '2022-01-01'
group by 1,2
order by 1 asc