简单SQL语句面试题

问题一：查询出所有学生的信息

SELECT * FROM student;

问题二：查询学号为1001的学生的姓名和性别

SELECT name, gender FROM student WHERE student_id=1001;

问题三：查询所有女生的姓名、年龄和班级

SELECT name, age, class FROM student WHERE gender='女';

问题四：查询姓“王”的老师的个数

SELECT COUNT(*) FROM teacher WHERE name LIKE '王%';

问题五：查询没有学生选修的课程信息

SELECT * FROM course WHERE course_id NOT IN(SELECT course_id FROM sc);

问题六：查询选修了编号为1的课程的学生学号和姓名

SELECT student.student_id, student.name FROM student, sc WHERE student.student_id=sc.student_id AND sc.course_id=1;

问题七：查询选修了两门以上课程的学生学号和姓名

SELECT student.student_id, student.name FROM student, sc WHERE student.student_id=sc.student_id GROUP BY student.student_id HAVING COUNT(sc.course_id)>=2;