SELECT id_klienta, COUNT(*) AS liczba_zamowien FROM zamowienia GROUP BY id_klienta ORDER BY liczba_zamowien DESC;