InterviewBit Academy is now Scaler!
Learn Tech Skills from Scratch @ Scaler EDGE

Actors and their Movies

Write a SQL Query to find the name of those movies where one or more actors acted in two or more movies.

Output Schema:



  • Output column name has to match the given output schema.
  • Any name is the concatenation(without any delimiter) of first and last name if present
  • (E.g. if director_first_name is ‘Alfred’ and director_last_name is ‘Hitchcock’ then director_name is ‘AlfredHitchcock’)

Example Output:


Schema Design:

Schema Description

NOTE: You only need to implement the given function. Do not read input, instead use the arguments to the function. Do not print the output, instead return values as specified. Still have a doubt? Checkout Sample Codes for more details.
  • Hints are not available for this problem


Click here to start solving coding interview questions