with luna_price as (
SELECT block_timestamp::date as date, avg(price_usd) as price,
case when price >= 52 then 'Above 52'
else 'Below 52' end as label
FROM terra.oracle_prices
WHERE date >= '2021-12-01'
AND date < '2022-03-10'
AND symbol = 'LUNA'
GROUP BY 1
ORDER BY 1
)
select label, count(*) as total_days from luna_price group by 1