### Database Schema:
CREATE TABLE taughtBy (
	course_id	INTEGER	NULL	PRIMARY KEY,
	p_id	INTEGER	NULL	PRIMARY KEY,
	foreign key (course_id) references course (course_id),
	foreign key (p_id) references person (p_id)
);

CREATE TABLE course (
	course_id	INTEGER	NULL	PRIMARY KEY,
	courseLevel	TEXT	NULL
);

CREATE TABLE person (
	p_id	INTEGER	NULL	PRIMARY KEY,
	professor	INTEGER	NULL,
	student	INTEGER	NULL,
	hasPosition	TEXT	NULL,
	inPhase	TEXT	NULL,
	yearsInProgram	TEXT	NULL
);

CREATE TABLE advisedBy (
	p_id	INTEGER	NULL	PRIMARY KEY,
	p_id_dummy	INTEGER	NULL	PRIMARY KEY,
	foreign key (p_id) references person (p_id),
	foreign key (p_id_dummy) references person (p_id)
);

### User's Query:
How many students that are undergoing the pre-phase of qualification have advisors?

### Extra Knowledge:
students refers to student = 1 and ; undergoing the phase of pre-qualification refers to inPhase = 'Pre-Quals'; have advisors refers to advisedBy.p_id
SELECT COUNT(T1.p_id_dummy) FROM advisedBy AS T1 INNER JOIN person AS T2 ON T1.p_id = T2.p_id WHERE T2.inPhase = 'Pre_Quals' AND T2.student = 1