---

SELECT
    np.contract_id,
    np.payment_type_code,
    np.numb_of_monts,
    np.effective_date,
    np.ops_payment_decision_id
FROM back_office.ops_number_of_payments np
WHERE np.contract_id = 9655101
  AND np.effective_date < DATE '2026-06-01'
ORDER BY
    np.effective_date DESC,
    np.numb_of_monts DESC
LIMIT 10;