with tab1 as (
SELECT
buyer,
sum(price) as amount
FROM flow.core.fact_nft_sales
GROUP BY 1
)
SELECT
date_trunc('day', block_timestamp),
CASE
WHEN buyer in (SELECT buyer FROM tab1 where amount > 1000) THEN 'Whale' ELSE 'Other' END,
sum(price) as volume
FROM flow.core.fact_nft_sales
GROUP BY 1,2