question

charmila avatar image
charmila asked

For each year, count the number of movies in that year that had only female actors

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

sqlquerydatabase
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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.

0 Likes 0 ·

1 Answer

·
Jon Crawford avatar image
Jon Crawford answered

Look up NOT EXISTS() to help you with this one.

1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Can you please tell me in detail

0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.