### 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:
Define the gender of "student995" and his/her enrolled schools.

### Extra Knowledge:
male.name = 'student995' means student995's gender is male; if 'student995' can not be found in 'male.name', it means student995 is female;
SELECT IIF(T2.name IS NULL, 'female', 'male') AS gen , T1.school FROM enrolled AS T1 LEFT JOIN male AS T2 ON T2.name = T1.name WHERE T1.name = 'student995'