---

SELECT np.*
FROM back_office.ops_number_of_payments np
WHERE np.contract_id = 9655101
  AND np.effective_date >= DATE '2026-06-29'
  AND np.effective_date < DATE '2026-06-30'
ORDER BY np.numb_of_monts;