In SQL, we have a table casting, which maps actor_id with movie_id. Find the pair of actors, who acted together for the most time. if you have multiple combos, you can return any of them.
AnswerBot
8mo
Find the pair of actors who acted together for the most time in a SQL table.
Join the casting table with itself on movie_id to get pairs of actors who acted together.
Calculate the total time they acted...read more
Help your peers!
Add answer anonymously...
Top R Systems International Senior Software Engineer interview questions & answers
Popular interview questions of Senior Software Engineer
Top HR questions asked in R Systems International Senior Software Engineer
>
R Systems International Senior Software Engineer Interview Questions
Stay ahead in your career. Get AmbitionBox app
Helping over 1 Crore job seekers every month in choosing their right fit company
65 L+
Reviews
4 L+
Interviews
4 Cr+
Salaries
1 Cr+
Users/Month
Contribute to help millions
Get AmbitionBox app
Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.
Follow us
