update analysis.orders_v
set status = 0;

update analysis.orders_v
set status = query1.status
from (select
        orderstatuslog_v.order_id,
        last_value(orderstatuslog_v.status_id) over (partition by orderstatuslog_v.order_id
                                 order by orderstatuslog_v.dttm asc
                                 rows between unbounded preceding and unbounded following) as status
      from
        analysis.orderstatuslog_v) as query1
where query1.order_id = analysis.orders_v.order_id;