แต่ละละครมีนักแสดงกี่คน?ไม่จำเป็นต้องใช้โต๊ะทั้งหมด
How many actors have appeared in each musical?It is not neccessary to use all the tables.
 musical:  musical_id [ number]  name [ text]  year [ number]  award [ text]  category [ text]  nominee [ text]  result [ text] 
SELECT T2.name, COUNT(*) FROM actor AS T1 JOIN musical AS T2 ON T1.musical_id = T2.musical_id GROUP BY T1.musical_id