CREATE TABLE department (dept_name VARCHAR)

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" NULLS FIRST