（1）查询所有学生的学号、姓名、课程号和成绩。

SELECT student.id AS 学号, student.name AS 姓名, course.id AS 课程号, score.score AS 成绩
FROM student
INNER JOIN score ON student.id = score.student_id
INNER JOIN course ON score.course_id = course.id;