Day21Hw - FROM people AS p INNER JOIN births AS b ON...

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

View Full Document Right Arrow Icon
SELECT last_name, first_name, YEAR(NOW())-YEAR(birthdate) FROM people AS p INNER JOIN births AS b ON p.person_id = b.person_id INNER JOIN movie_actors AS ma ON ma.person_id=p.person_id INNER JOIN movies as m ON m.movie_id = ma.movie_id WHERE title ="Ten Commandments, The" AND release_year =1956 SELECT last_name, first_name, YEAR(NOW())-YEAR(birthdate)
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: FROM people AS p INNER JOIN births AS b ON p.person_id = b.person_id INNER JOIN movie_actors AS ma ON ma.person_id=p.person_id INNER JOIN movies AS m ON m.movie_id = ma.movie_id LEFT JOIN deaths AS d ON d.person_id = p.person_id WHERE title ="Ten Commandments, The" AND release_year =1956 AND deathdate IS NULL...
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