④ 设计视图，查询同时上了2门以上课程的教师号、姓名、专业、职称、任课课程计数及平均评价。...

可以使用如下的 SQL 语句来设计视图：

CREATE VIEW v_teacher_multiple_courses AS
SELECT t.teacher_id, t.name, t.major, t.title, COUNT(c.course_id) AS course_count, AVG(c.evaluation) AS avg_evaluation
FROM teachers t
INNER JOIN courses c ON t.teacher_id = c.teacher_id
GROUP BY t.teacher_id, t.name, t.major, t.title
HAVING COUNT(c.course_id) >= 2;