DROP TABLE IF EXISTS Films;
CREATE TABLE Films
(
id INT PRIMARY KEY AUTO_INCREMENT,
title VARCHAR(20),
director VARCHAR(20)
);
INSERT INTO Films (title, director)
VALUES ('Toy Story 2', 'John Lasseter'),
('WALL-E', 'Andrew Stanton'),
('Ratatouille', 'Brad Bird'),
('Up', 'Pete Docter'),
('Brave', 'Brenda Chapman'),
('Monsters University', 'Dan Scanlon'),
('Cars 2', 'John Lasseter'),
('Finding Nemo', 'Andrew Stanton'),
('Toy Story', 'John Lasseter'),
('The Incredibles', 'Brad Bird');
SELECT title
FROM Films
ORDER BY RAND()
LIMIT 5