Problem
Consider IMDB data set.
Write SQL and choose result that corresponds to your SQL
Requirements:
1) Consider only movies genre='Western
2) Consider only the movies that have been ranked.
3) Display ID, First name, Last Name and Ranking for top 5 actors.
4) Combine first and last name, use only first 10 characters from both. Separate first and last name with space
5) The ranking is based on number of movies actor has participated in that answer criteria above
6) Highest number of Movies gets ranking 1
7) Use RANK() function to calculate ranking.