Answer:
CREATE FUNCTION exam_eligible_students
RETURN NUMBER AS
num_students NUMBER(15);
BEGIN
SELECT COUNT(STUDENT_ID)
INTO num_students
FROM STUDENT_ATTENDANCE
WHERE ELIGIBILITY_FOR_EXAMS = 'Y';
RETURN (num_students);
END;
Explanation:
exam_eligible_students is a made of name for the FUNCTION to be called.
num_students is a made up name for the RETURN to be called. The RETURN name is referenced in the INTO statement and as the name of the the return in the RETURN line in ().
The answer to your question is,
D. Toggle Filter. You don't want to remove the filter, you just want to see the difference.
-Mabel <3