-- 检索计算机系同学与男同学的交集
SELECT * 
FROM student
WHERE deptNo = (SELECT deptNo FROM department WHERE dept_name = '计算机科学与技术') AND gender = 'M';

--