SELECT dept_name FROM department ORDER BY dept_name
list names of all departments ordered by their names.
SELECT dept_name FROM department ORDER BY dept_name
select dept_name from department order by dept_name
list names of all departments ordered by their names .