What is the total amount male and female actors who were casted in movie ID 1684910 and what is the proportion between the highest quality actors against the worst quality of actors? Indicate your answer in percentage. List the the director as well as the genre.
Female actors mean that a_gender = 'F'; Male actors mean that a_gender = 'M'; a_quality = 5 refers to act the best, a_quality = 0 refers to act the worst
SELECT SUM(IIF(a_gender = 'M', 1, 0)) , SUM(IIF(a_gender = 'F', 1, 0)) , CAST(SUM(IIF(a_quality = 5, 1, 0)) AS REAL) * 100 / COUNT(*) , CAST(SUM(IIF(a_quality = 0, 1, 0)) AS REAL) * 100 / COUNT(*), ( SELECT directorid FROM movies2directors WHERE movieid = 1684910 ) , ( SELECT genre FROM movies2directors WHERE movieid = 1684910 ) FROM actors WHERE actorid IN ( SELECT actorid FROM movies2actors WHERE movieid = 1684910 )
database name:db_id movielens
users table users Cols: user id dtype integer, age dtype text, user gender dtype text, occupation dtype text, 
directors table directors Cols: director id dtype integer, director quality dtype integer, average revenue dtype integer, 
actors table actors Cols: actor id dtype integer, actor gender dtype text, actor quality dtype integer, 
movies table movies Cols: movie id dtype integer, year dtype integer, is English dtype text, country dtype text, runningtime dtype integer, 
movies2actors table movies2actors Cols: movie id dtype integer, actor id dtype integer, cast number dtype integer, 
movies2directors table movies2directors Cols: movie id dtype integer, director id dtype integer, genre dtype text, 
u2base table u2base Cols: user id dtype integer, movie id dtype integer, rating dtype text, 
