(transaction_date between date_sub(now(), interval 7 day) and now())
then 'week'
else 'month' end as week_or_month