What are the names of all departments in alphabetical order?
SELECT dept_name FROM department ORDER BY dept_name
names of all departments refers to dept_name; alphabetical order refers to ORDER BY dept_name ASC (though ASC is default and thus optional);