Table: college_exam_results
Columns: subject
no_sat
no_passed
pass
highest_mark
lowest_mark
mean

Question: What is the subject when the highest mark is 79?
SQL: SELECT "subject" FROM college_exam_results WHERE "highest_mark" = 79

Question: How many lowest mark entries are there when % passed is 76?
SQL: SELECT COUNT("lowest_mark") FROM college_exam_results WHERE "pass" = 76