$4\mathrm{.}5$ Querying an ERD $(8$ pts$)$

Write a SQL Statement that gives me a count of all the actors that have played the same role in

more than one movie $($for example Emma Watson played Hermione Granger $8$ times$).$ The

output should have four columns: First, Last, Role, and CountQfRole.