SELECT
	ssm.STUDENT_ID,
	ssm.SCHOOL_ID,
	s2.MP
FROM
	STUDENTS s
INNER JOIN
	STUDENT_ENROLLMENT ssm
	ON s.STUDENT_ID = ssm.STUDENT_ID
LEFT OUTER JOIN
	SCHEDULE s2
	ON s2.STUDENT_ID=ssm.STUDENT_ID
	AND s2.SYEAR=ssm.SYEAR
	AND s2.SCHOOL_ID=ssm.SCHOOL_ID
	AND (s2.END_DATE IS NULL OR s2.END_DATE >= '2014-05-14')
LEFT OUTER JOIN
	COURSE_PERIODS cp2
	ON cp2.SYEAR=s2.SYEAR
	AND cp2.SCHOOL_ID=s2.SCHOOL_ID
	AND cp2.COURSE_PERIOD_ID=s2.COURSE_PERIOD_ID
WHERE
	ssm.SCHOOL_ID='13'
	AND ssm.SYEAR='2014'
	AND ('14-MAY-14' BETWEEN ssm.START_DATE AND ssm.END_DATE OR (ssm.END_DATE IS NULL))