Fixed the case statement
SELECT id
FROM education_program
WHERE name = CASE %s
WHEN 'SENIOR HIGH SCHOOL GAS'
THEN 'General Academic Strand'
WHEN 'SENIOR HIGH SCHOOL HUMSS'
THEN 'Humanities and Social Sciences'
WHEN 'SENIOR HIGH SCHOOL STEM'
THEN 'Science, Technology, Engineering and Mathematics'
ELSE %s
END
AND department_id
IN (SELECT id
FROM profile_department
WHERE school_id=1)
""", [course, course])