### 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:
What is the school and gender of student34?

### Extra Knowledge:
male.name = 'student34' means student34's gender is male; if 'student34' can't be found in 'male.name', it means student34 is female; student34 is a name of student;
SELECT T1.school , IIF(T3.name IS NULL, 'female', 'male') AS gender FROM enrolled AS T1 INNER JOIN person AS T2 ON T1.name = T2.name LEFT JOIN male AS T3 ON T2.name = T3.name WHERE T2.name = 'student34'