Finance wants every customer who has at least one order that is not paid. An order whose status is NULL (unknown) also counts as not paid — it hasn't been confirmed.
Return customer_id and not_paid_orders (how many of their orders are not paid, counting NULL statuses). Only include customers with at least one such order. Sort by customer_id.