This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: ON m.movie_id = mg.movie_id WHERE release_year = 2004 GROUP BY genre_code ORDER BY COUNT(m.movie_id) DESC Find the earliest release_year when Jet Li starred in movies for each of the different languages (use language_codes) his movies have been in. Show language_code and release_year only for the languages in which he has made at least 3 movies. Sort the list chronologically (i.e., by date). [4; first row is MANDR, 1982]-----SELECT language_code, MIN(release_year) AS Earliest 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 INNER JOIN movie_languages AS ml ON m.movie_id = ml.movie_id WHERE first_name = "Jet" AND last_name = "Li" GROUP BY language_code HAVING COUNT(language_code) >2 ORDER BY MIN(release_year)...
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