list names of all departments ordered by their names.
SELECT dept_name FROM department ORDER BY dept_name
list names of all departments refers to SELECT dept_name FROM department; ordered by their names refers to ORDER BY dept_name;