select
    user_id,
    max(order_ts) over (partition by user_id) as last_order_date, -- дата последнего заказа
    count(*) over (partition by user_id) as sum_orders, -- количество заказов у каждого клиента
    sum(payment) over (partition by user_id) as sum_payment -- сумма заказов по клиенту
  from
    analysis.users_v u left join analysis.orders_v o on u.id = o.user_id
  where
    order_ts > '2021-01-01' and status = 4