CSC 371 Lecture Notes - Lecture 17: Star Media Group, Data Definition Language
22 Jun 2016
School
Department
Course
Professor
Document Summary
Practice exercises pt 4: for each star that has more than two movies with paramount, nd how many movies he/she has with fox. This creates a table of actors who have at least two lms with paramount. This creates a table of stars who have starred in lms made by paramount. This joins the actors the two tables by actors name, we want an outer join because we want to include those stars who have not worked for paramount at all. Note: left outer join = left join: find the stars who have co-starred with the same star. Select x. starname as star1, y. starname as star2 from starsin x join starsin y. Where z. star2=w. star1 and z. star1
