where case when

select *
from vn09jj5.order_line
where paid_date >=
(
--(周五：同步7天,其他：同步1天)
case 
  when pmod(datediff(current_date(),'1920-01-01')-3,7)=5 then date(date_add(current_date(),-7))
  else date(date_add(current_date(),-1))
end  
)