Yahoo Clever wird am 4. Mai 2021 (Eastern Time, Zeitzone US-Ostküste) eingestellt. Ab dem 20. April 2021 (Eastern Time) ist die Website von Yahoo Clever nur noch im reinen Lesemodus verfügbar. Andere Yahoo Produkte oder Dienste oder Ihr Yahoo Account sind von diesen Änderungen nicht betroffen. Auf dieser Hilfeseite finden Sie weitere Informationen zur Einstellung von Yahoo Clever und dazu, wie Sie Ihre Daten herunterladen.

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 Antwort

Relevanz
  • vor 1 Jahrzehnt
    Beste Antwort

    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.)

Haben Sie noch Fragen? Jetzt beantworten lassen.