Instruction: Create a temporary table called VIEW that gives you list of movie from the movie table that has greater than 8,000,000 views.
(Note: Views do not store data themselves and updates automatically as the source tables data updates.)
CREATE VIEW Jamesbond AS
SELECT name, view from movies
WHERE view>8,000,000
No comments:
Post a Comment