This preview shows page 1. Sign up to view the full content.
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.
- Fall '08