select count(user_id)
from
(select
    user_id
 from
    analysis.users_v u
 left join (select
            distinct(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.orders_v
            where order_ts > '2021-01-01' and status = 4) o
 on u.id = o.user_id) q1