Hi, I have this kind of error when compiling it

ERROR: syntax error at or near "1" LINE 5: HAVING COUNT 1 =<(SELECT e.dname FROM enroll e JOIN dept d O... ^

Here is what I'm trying to find the sid and name of students majoring in 'Civil Engineering' who have enrolled in at least one course offered by the 'Chemical Engineering' department.

My code is

SELECT s.sid, s.sname FROM student s JOIN major m ON s.sid=m.sid WHERE m.dname = 'Civil Engineering' GROUP BY s.sid HAVING COUNT 1 =<(SELECT e.dname FROM enroll e JOIN dept d ON e.dname=d.dname WHERE e.dname = 'Chemical Engineering')