If i remove the Concat from the having, then wouldn't it just bring back any single actor that has appeared twice instead of the condition I want?

We do the "from table" like this at work, I always just thought that's how PL/SQL's syntax is and not a matter of old vs new. Good to know.

With the...

Hello, thanks for the reply.

Maybe I misunderstood your reply but doing that only gives me the total count of actors in each movie. It doesn't tell me who worked with...