SELECT rec.title AS title,
 count(distinct keywords.keyword)
 + 10 * count(distinct people.id)
 AS score

FROM movies AS rec
JOIN credits ON rec.id = credits.movie_id AND credits.type = 'actor'
JOIN people ON people.id = credits.person_id

JOIN keywords ON keywords.movie_id = rec.id

WHERE keywords.keyword IN(
  SELECT keywords.keyword
  FROM keywords
  JOIN movies ON movies.id = keywords.movie_id
  WHERE movies.title = 'Skyfall (2012)')

AND people.id IN (
  SELECT people.id
  FROM people
  JOIN credits ON credits.person_id = people.id AND credits.type = 'actor'
  JOIN movies ON credits.movie_id = movies.id
  WHERE movies.title = 'Skyfall (2012)'
)
AND count(distinct keywords.keyword) > 0
AND count(distinct people.id) > 0

GROUP BY rec.title
ORDER BY score DESC;