Task: Text to Code
Input (English): SQL: SELECT Name , Count ( * ) FROM actor GROUP BY Name
Feedback: Replace actor table with musical table . corresponding rows to each value of musical id , make sure that musical id present in actor table .
Output (English): SELECT T2.Name ,  COUNT(*) FROM actor AS T1 JOIN musical AS T2 ON T1.Musical_ID  =  T2.Musical_ID GROUP BY T1.Musical_ID