Problemas con consulta

[ZedGe1505]

Lo que necesitas es un GROUP BY

Código MySQL:

SELECT SUM(`monto`) as monto FROM `mitabla`WHERE `codigo`LIKE '%CM%' GROUP BY proveedor ORDER BY monto DESC