### 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 employment, disability, gender and school debt status for student180 and student117?

### Extra Knowledge:
school debt status refers to bool; bool = 'pos' means has payment due; bool = 'neg' means doesn't has payment due; student appear in male.name means he is a male; student does not appear in male.name means she is a female;
SELECT ( SELECT COUNT(name) FROM disabled WHERE name IN ('student180', 'student117') ), ( SELECT COUNT(name) FROM unemployed WHERE name IN ('student180', 'student117') ), ( SELECT COUNT(name) FROM male WHERE name IN ('student180', 'student117') ), ( SELECT COUNT(name) FROM no_payment_due WHERE name IN ('student180', 'student117'))