sql语句错误之Every derived table must have its own alias

-- Write your SQL Query here --
-- example: SELECT * FROM XX_TABLE WHERE XXX --
-- 连接 teachers 表和 courses 表，并将查询的课程名称（起别名为 course_name）、学生总数、
-- 讲师姓名（起别名为 teacher_name）信息作为查询表，并从该查询表中选出学生总数最多的信息。
select * from (select c.name course_name,c.student_count,t.name teacher_name 
from teachers t,courses c where t.id = c.teacher_id)
where student_count = (select max(student_count) from courses)

上述sql语句报错

Every derived table must have its own alias

根源出在from 后应该有表名，因此需要手动起名

(select c.name course_name,c.student_count,t.name teacher_name 
from teachers t,courses c where t.id = c.teacher_id)

需要为其指定别名

select * from (select c.name course_name,c.student_count,t.name teacher_name 
from teachers t,courses c where t.id = c.teacher_id) AS `X`
where student_count = (select max(student_count) from courses)