### Database Schema:
CREATE TABLE unemployed (
	name	TEXT	NOT NULL	DEFAULT ''	PRIMARY KEY,
	foreign key (name) references person (name)
);

CREATE TABLE disabled (
	name	TEXT	NOT NULL	DEFAULT ''	PRIMARY KEY,
	foreign key (name) references person (name)
);

CREATE TABLE male (
	name	TEXT	NOT NULL	DEFAULT ''	PRIMARY KEY,
	foreign key (name) references person (name)
);

CREATE TABLE no_payment_due (
	name	TEXT	NOT NULL	DEFAULT ''	PRIMARY KEY,
	bool	TEXT	NULL,
	foreign key (bool) references bool (name),
	foreign key (name) references person (name)
);

CREATE TABLE enrolled (
	name	TEXT	NOT NULL	PRIMARY KEY,
	school	TEXT	NOT NULL	PRIMARY KEY,
	month	INTEGER	NOT NULL	DEFAULT 0,
	foreign key (name) references person (name)
);

CREATE TABLE longest_absense_from_school (
	name	TEXT	NOT NULL	DEFAULT ''	PRIMARY KEY,
	month	INTEGER	NULL	DEFAULT 0,
	foreign key (name) references person (name)
);

CREATE TABLE bool (
	name	TEXT	NOT NULL	DEFAULT ''	PRIMARY KEY
);

CREATE TABLE enlist (
	name	TEXT	NOT NULL,
	organ	TEXT	NOT NULL,
	foreign key (name) references person (name)
);

CREATE TABLE filed_for_bankrupcy (
	name	TEXT	NOT NULL	DEFAULT ''	PRIMARY KEY,
	foreign key (name) references person (name)
);

CREATE TABLE person (
	name	TEXT	NOT NULL	DEFAULT ''	PRIMARY KEY
);

### User's Query:
Calculate the ratio in percentage between the average number of female and male students who joined Fire Department organization.

### Extra Knowledge:
ratio = CONCAT(MULTIPLY(DIVIDE(COUNT(enlist.name WHERE organ = 'fire_department' which is NOT in male.name), COUNT(enlist.name WHERE organ = 'fire_department),'%'))) AS FEMALE; ratio = CONCAT(MULTIPLY(DIVIDE(COUNT(enlist.name WHERE organ = 'fire_department' which is IN male.name), COUNT(enlist.name WHERE organ = 'fire_department), 100))) AS MALE; female students refers to enlist.name who are NOT in male.name; male students refers to enlist.name who are IN male.name; organization refers to organ; organ = 'fire_department';
SELECT CAST(SUM(IIF(T2.name IS NULL, 1, 0)) AS REAL) * 100 / COUNT(T1.name), CAST(SUM(IIF(T2.name IS NOT NULL, 1, 0)) AS REAL) * 100 / COUNT(T1.name) FROM enlist AS T1 LEFT JOIN male AS T2 ON T2.name = T1.name WHERE T1.organ = 'fire_department'