Create count-student-number-in-departments�.sql

kamyu104 · web-flow · commit c9d02222998c · 2017-11-18T09:06:34.000-06:00
diff --git a/MySQL/count-student-number-in-departments.sql b/MySQL/count-student-number-in-departments.sql
@@ -0,0 +1,12 @@
+# Time:  O(s+dlogd)
+# Space: O(d+s)
+
+SELECT
+    dept_name, COUNT(student_id) AS student_number
+FROM
+    department
+        LEFT JOIN
+    student ON department.dept_id = student.dept_id
+GROUP BY department.dept_name
+ORDER BY student_number DESC , department.dept_name
+;
