Question

There is database name movies and there are 5 tables.
1. Movie - \id ,\name
2. actor - \id,\name
3. award - \id, \name
4. movie_cast (many many relationship) - \movie_id(foreign key),\actor_id(foreign key)
5. award_results - \year, \award_id,\movie_id
Q1. List of all actors without any award winning movie
Q2. List of actors with maximum number of awards winning movies by year

Answer 1

Answer:

movie - \id ,\name real hero

Answer 2

I don't know but I will try it tomorrow