Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
sql query help please?
Question::List the actorID,firstname,and last name of actors who have ONLY played in drama movies,together with the number of drama movies each actor played. output should be in descending order of number of movies each actor played
the databse is here
MovieInfo(mvid,title,firstname,lastname) where mvid is primary key
Cast(mvID*,actorID*) both of the attribute are primary and forign key
Actor(actorID,firstname,lastname,genre,birthplace) actorID is primary key
Genre(mvID*,genre) mvid and genre both are primary key and mvid is foreign key too
Thanks in advance
1 Answer
- TheMadProfessorLv 71 decade agoFavorite Answer
Didn't I just answer a very similar question for you the other day? The answer to that one would've gotten you about 2/3 of the way there on this one. (However, the other question has mysteriously disappeared - looks like someone doesn't want to leave evidence they're getting help on homework...)
At least make an attempt on this one by yourself and, if you get stuck, drop me a line. (BTW, your database structure looks suspect - I would not expect firstname/lastname in MovieInfo and genre probably shouldn't be in Actor.)