Day18Queries - FROM people INNER JOIN deaths ON...

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

View Full Document Right Arrow Icon
SELECT first_name, last_name, birthdate FROM people INNER JOIN births ON people.person_id = births.person_id WHERE country = "Cuba"; SELECT title, notes FROM movies INNER JOIN movie_ratings ON movies.movie_id = movie_ratings.movie_id WHERE release_year = 2003 AND rating_code = "PG-13"; SELECT title, release_year FROM movies INNER JOIN movie_genres ON movies.movie_id = movie_genres.movie_id WHERE genre_code = "ANI" AND release_year > 2001; SELECT first_name, last_name
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 INNER JOIN deaths ON people.person_id = deaths.person_id WHERE deathdate IS NOT NULL; SELECT first_name, last_name, city, state FROM people INNER JOIN births ON people.person_id = births.person_id WHERE state = "Michigan" OR state = "Ohio"; SELECT title, release_year FROM movies INNER JOIN movie_languages ON movies.movie_id = movie_languages.movie_id WHERE language_code = "JAPNS" AND release_year >= 2005;...
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