Usei o código:
SELECT id_pagamento, datapagamento, valor, status
from TabelaPagamentos
where datapagamento like '2023%' and
valor BETWEEN 500 and 1000
ORDER by valor asc;
Usei o código:
SELECT id_pagamento, datapagamento, valor, status
from TabelaPagamentos
where datapagamento like '2023%' and
valor BETWEEN 500 and 1000
ORDER by valor asc;