select date(recorded_at) as Date,

avg(price) as "SCRT price",

case when Date>CURRENT_DATE-8 then 'Current week' else 'other days' end as "Date status"

from osmosis.core.dim_prices

where symbol = 'SCRT' and Date<CURRENT_DATE --and Date>CURRENT_DATE-91

group by 1

order by 1 asc