The SELECT statement returns results from a table. In this example the table is games and the columns are yr and city.

SELECT yr, city FROM 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);

SELECT yr, city FROM games