### Database Schema:
CREATE TABLE users (
	userid	INTEGER	NOT NULL	DEFAULT 0	PRIMARY KEY,
	age	TEXT	NOT NULL,
	u_gender	TEXT	NOT NULL,
	occupation	TEXT	NOT NULL
);

CREATE TABLE directors (
	directorid	INTEGER	NOT NULL	PRIMARY KEY,
	d_quality	INTEGER	NOT NULL,
	avg_revenue	INTEGER	NOT NULL
);

CREATE TABLE u2base (
	userid	INTEGER	NOT NULL	DEFAULT 0	PRIMARY KEY,
	movieid	INTEGER	NOT NULL	PRIMARY KEY,
	rating	TEXT	NOT NULL,
	foreign key (userid) references users (userid),
	foreign key (movieid) references movies (movieid)
);

CREATE TABLE movies2actors (
	movieid	INTEGER	NOT NULL	PRIMARY KEY,
	actorid	INTEGER	NOT NULL	PRIMARY KEY,
	cast_num	INTEGER	NOT NULL,
	foreign key (actorid) references actors (actorid),
	foreign key (movieid) references movies (movieid)
);

CREATE TABLE movies (
	movieid	INTEGER	NOT NULL	DEFAULT 0	PRIMARY KEY,
	year	INTEGER	NOT NULL,
	isEnglish	TEXT	NOT NULL,
	country	TEXT	NOT NULL,
	runningtime	INTEGER	NOT NULL
);

CREATE TABLE actors (
	actorid	INTEGER	NOT NULL	PRIMARY KEY,
	a_gender	TEXT	NOT NULL,
	a_quality	INTEGER	NOT NULL
);

CREATE TABLE movies2directors (
	movieid	INTEGER	NOT NULL	PRIMARY KEY,
	directorid	INTEGER	NOT NULL	PRIMARY KEY,
	genre	TEXT	NOT NULL,
	foreign key (movieid) references movies (movieid),
	foreign key (directorid) references directors (directorid)
);

### User's Query:
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.

### Extra Knowledge:
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 )