A movie table which has MID (Primary key),TITLE,YEAR,RATING,NUM_VOTES. A Person table has PID (Primary Key),NAME,DOB,GENDER. A M_Cast table has ID(Primary), MID(Foreign key), PID(Foreign Key
asked
For each year, count the number of movies in that year that had only female actors
This looks like a homework question. I'm guessing you're unlikely to get a full answer given to you, but are more likely to be guided towards learning how to do this for yourself.
19 People are following this question.
