I'm new to this so bear with me.
I'm trying to create a select query from a
roleID, roleName, gender, actorID, movieID
SELECT COUNT (DISTINCT actorID) FROM Role WHERE actorID >= 3
SELECT COUNT (actorID) FROM Role GROUP BY movieID HAVING COUNT (actorID) >=3
Try something like:
select actorID, count(*) from Roles group by actorID having count (*) >= 3
If you want to retrieve other properties about the actor you add those to both the select and group by clauses