SELECT NumeroContrat COUNT(NumeroProposition) as Propositions
FROM table
GROUP BY NumeroContrat
ORDER BY NumeroContrat;

pub :zen: :...