Given the relation Movies(title, year, length, genre. studioName). Select the right query to create a View with the titles and studio names of all movies that were produced in 1980
[A]
CREATE VIEW OldMovies SELECT title. studioName FROM Movies WHERE year-1980
[B]
CREATE VIEW OldMovies SELECT title, year FROM Movies WHERE year=1980
[C]
CREATE VIEW OldMovies AS SELECT title. studioName FROM Movies WHERE year=1980
[D]
None of the others
Answer: C