MySQL中查询计算机系的所有学生 有 teacher, student, course, scor

MySQL中查询计算机系的所有学生 有 teacher, student, course, score四个表

select count(*) as '所有学生' from student

select count(*) from student,
student as s,
course as c
where student.id = s.student_id
and student.id = c.student_id
and c.course_name = '计算机系'