# SELECT Publisher, COUNT(*) AS 'Number' FROM books GROUP BY Publisher ORDER BY Number DESC; +-----------+--------+ | Publisher | Number | +-----------+--------+ | Rheinwerk | 10 | | O'Reilly | 6 | | Wiley | 5 | | Hanser | 5 | | Mitp | 4 | | C.H. Beck | 2 | | Tintal | 1 | | Franzis | 1 | | Dpunkt | 1 | | Apress | 1 | +-----------+--------+