Day19Queries - SELECT first_name last_name deathdate FROM people As p LEFT JOIN deaths As d ON p.person_id = d.person_id WHERE deathdate IS NULL

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

View Full Document Right Arrow Icon
SELECT title, release_year FROM movies AS m INNER JOIN movie_actors AS ma ON m.movie_id = ma.movie_id INNER JOIN people AS p ON p.person_id = ma.person_id WHERE first_name = "Robert" AND last_name = "Redford" SELECT first_name, last_name, title, release_year FROM movies AS m INNER JOIN movie_personnel AS mp ON m.movie_id = mp.movie_id INNER JOIN people AS p ON p.person_id = mp.person_id WHERE title LIKE "%Frankenstein%" AND activity_code = "DIR" SELECT first_name, last_name, deathdate FROM people As p INNER JOIN deaths As d ON p.person_id = d.person_id WHERE deathdate IS NOT NULL AND last_name = "Brynner"
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 first_name, last_name, deathdate FROM people As p LEFT JOIN deaths As d ON p.person_id = d.person_id WHERE deathdate IS NULL AND last_name = "Brynner" SELECT first_name, last_name, title, rating_code FROM people AS p INNER JOIN movie_personnel AS mp ON p.person_id = mp.person_id INNER JOIN movies AS m ON m.movie_id = mp.movie_id LEFT JOIN movie_ratings AS mr ON m.movie_id = mr.movie_id WHERE release_year = 2008 AND activity_code = "DIR" AND rating_code IS NULL ORDER BY last_name, first_name...
View Full Document

This note was uploaded on 12/14/2011 for the course CSE 101 taught by Professor Allusethis during the Fall '08 term at Michigan State University.

Ask a homework question - tutors are online