SQL：选择没有嵌套查询的查询

Question

我有下一个输入数据， 我需要编写两个表

create table Courses(
id number(19) not null,
name varchar(100),
);

create table Students (
id number (19) not null,
name varchar(100),
course_id number (19) not null,
);

来获取所有学生人数（例如超过 10 人）的课程 所以，我写了带有嵌套查询的变体，如下所示

select distinct courses.name from student, courses where courses.id=student.courses_id and (select count(Students.id) from Students where student.course_id = course.id)  > 10 

！没有测试，只是写这篇文章，它是例子！ 所以，我的问题是如何在没有嵌套查询的情况下编写相同的查询？

Answer 1

使用GROUP BY/HAVING子句：

SELECT courses.name /*, COUNT(*)*/
FROM student JOIN courses ON courses.id = student.courses_id
GROUP BY courses.id
HAVING COUNT(*) > 10

Answer 2

我会和

Select c.name, count(s.id) as StudentsCount from Courses c join stundets S on c.id = s.course_id group by c.name having count(s.id) > 10