Count Student Number in Departments

LeetCode Link

Problem Description

Visit LeetCode for the full problem description.

---

Solutions

Solution 1: MySQL (Best: 1619 ms)

Metric	Value
Runtime	1619 ms
Memory	N/A
Date	2018-06-20

Solution

# Write your MySQL query statement below

select dept_name, COALESCE(student_number,0)  as student_number from department d left outer join
(select dept_id, count(*) as student_number from student group by dept_id) s on s.dept_id = d.dept_id
order by student_number desc, dept_name

---

Complexity Analysis

Approach	Time	Space
Solution	To be analyzed	To be analyzed