Need help with MYSQL query

I have IMDB movies database and would need help with SQL to answer below questions. I have attached DB schema and database file. Q1. For each year the percentage of movies in that year with only female actors, and the total number of movies made that year. For example, one answer will be: 1990 31.81 13522 meaning that in 1990 there were 13,522 movies, and 31.81% had only female actors. You do not need to round your answer. The query should have 3 columns - year, percentage of movies with female cast, total number of movies for the year. Q2. The Shahrukh number of an actor is the length of the shortest path between the actor and Shahrukh Khan in the "co-acting" graph. That is, Shahrukh Khan has Shahrukh number 0; all actors who acted in the same film as Shahrukh have Shahrukh number 1; all actors who acted in the same film as some actor with Shahrukh number 1 have Shahrukh number 2, etc. Return all actors whose Shahrukh number is 2. Consider 'A' who has worked in a film with Shahrukh Khan. His number would be 1 now. Then consider 'B' who has worked with 'A' together in other film. His number would be 2. Similarly, actor 'C' who has worked with 'B' would have Shahrukh Kahn number 3. Essentially, we are forming a chain in such a way that we reach the Actor who has worked with Shahrukh Khan. So, in this problem, the output should be all actors who have worked with 'A' ,i.e., their Shahrukh Khan number should be 2. So, you have to find all B's.