Day19Hw - p.person_id=mp.person_id WHERE...

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

View Full Document Right Arrow Icon
SELECT first_name, last_name, role, credit_number 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 title= "English Patient, The" ORDER BY credit_number SELECT DISTINCT first_name, last_name, city, state, country FROM people AS p INNER JOIN births AS b ON p.person_id=b.person_id INNER JOIN movie_personnel AS mp ON
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: p.person_id=mp.person_id WHERE State="Idaho" AND activity_code="DIR" SELECT title, language_name FROM movies AS m INNER JOIN movie_languages AS ml ON m.movie_id = ml.movie_id INNER JOIN languages AS l ON l.language_code = ml.language_code WHERE release_year = 2002 AND title LIKE "Star*"...
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