SQL(2)---EXAMPLE

Great Example of SQL

• Find the title of each film

SELECT title FROM Movies;

(The table would print:)

• Find the director of each film

SELECT director FROM Movies;

(The table would print:)

• Find the title and director of each film

SELECT title, director FROM Movies;

(The table would print:)

• Find the title and year of each film

SELECT title, year FROM Movies;

(The table would print:)

• Find all the information for each film

SELECT * FROM Movies;

(The table would print:)