day17MySQL - SELECT description FROM genres WHERE...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
SELECT movie_id, title, release_year FROM movies; SELECT description FROM genres; SELECT first_name, last_name FROM people; SELECT * FROM people WHERE height = 71; SELECT * FROM people WHERE (first_name = "Gwyneth") SELECT * FROM movies WHERE release_year >= 2001; SELECT * FROM people WHERE (last_name = "Jones") AND (height <66); SELECT * FROM people WHERE (last_name = "Kwan") OR (first_name = "Kwan");
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: SELECT description FROM genres WHERE description &lt;&gt; &quot;drama&quot;; SELECT * FROM people WHERE last_name LIKE &quot;Wil%&quot;; SELECT * FROM births WHERE country IS NULL; SELECT * FROM people WHERE height IS NOT NULL ORDER BY height; SELECT first_name, last_name, height FROM people WHERE height BETWEEN 84 and 96 ORDER BY height DESC;...
View Full Document

Ask a homework question - tutors are online