CREATE VIEW Titles_names_ratings AS ( SELECT * FROM Title_principals NATURAL JOIN Title_basics NATURAL JOIN Name_basics NATURAL LEFT JOIN Title_ratings );