The CREATE VIEW names a SELECT query. That query may be used as if it were a table in many contexts.
In this example the VIEW old_games shows those games before 2006.

CREATE VIEW old_games AS SELECT yr,city FROM games WHERE yr<2006; SELECT * FROM old_games;
DROP VIEW old_games; DROP TABLE games CREATE TABLE games(yr INT, city VARCHAR(20)); INSERT INTO games(city,yr) VALUES ('Sydney',2000); INSERT INTO games(city,yr) VALUES ('Athens',2004); INSERT INTO games(city,yr) VALUES ('Beijing',2008); INSERT INTO games(city,yr) VALUES ('London',2012);

CREATE VIEW old_games AS
  SELECT yr,city FROM games
   WHERE yr<2006;

SELECT * FROM old_games;