commit 3068a78f21cced56351e6ae61177b5639ad2dc7b parent acc6c1c69800fcfc384f1ac7b5f4272239dddff3 Author: AndrewLockVI <andrewlaack1@gmail.com> Date: Sat, 15 Apr 2023 20:53:11 -0500 Classes with more than 5 students Diffstat:
| A | classes-more-than-5-students/classes-more-than-5-students.sql | | | 6 | ++++++ |
1 file changed, 6 insertions(+), 0 deletions(-)
diff --git a/classes-more-than-5-students/classes-more-than-5-students.sql b/classes-more-than-5-students/classes-more-than-5-students.sql @@ -0,0 +1,6 @@ +--Select all classes with 5 or more students +--Runtime: 543ms Beats: 69.13% +SELECT C.class +FROM Courses AS C +GROUP BY class +HAVING count(C.student) >= 5