FilesExpand file tree

master

/

_580.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

4 lines (4 loc) · 196 Bytes

master

/

_580.sql

Copy path

Top

File metadata and controls

• Code
• Blame

4 lines (4 loc) · 196 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

select d.dept_name, count(s.student_id) as student_number

from department d left join student s on d.dept_id = s.dept_id

group by d.dept_name

order by student_number desc, d.dept_name;