Mysql : multiple select count

Permisi agan agan, saya mau bertanya

Kalau misal saya punya tabel begini

+-------+--------+-------+
| JUDUL | RATING |  BY   |
+-------+--------+-------+
| Gelas |   5    | Asrul |
+-------+--------+-------+
| Gelas |  5     | Djoko |
+-------+--------+-------+
| Gelas |  3     | Anwar |
+-------+--------+-------+
| Gelas |  3     | Khoir |
+-------+--------+-------+
| Sirup |  5     | Anwar |
+-------+--------+-------+
| Sirup |  4     | Anwar |
+-------+--------+-------+
| Sirup |  4     | Djoko |
+-------+--------+-------+

Nah yang mau saya tanyain, kalau misal saya pengen hitung "Gelas rate 5 nya berapa, rate 4 nya berapa, dan seterusnya begitu juga dengan sirup". Itu gimana ya caranya kalau dengan COUNT() ?

Sehingga nanti hasilnya

+-------+--------+-------+-------+
| JUDUL | rate5  | rate4 | rate3 |
+-------+--------+-------+-------+
| Gelas |   2    |   0   |   2   |
+-------+--------+-------+-------+
| Sirup |   1    |   2   |   0   |
+-------+--------+-------+-------+

Terima kasih