SQL Answers Exercise 10-9

Exercise 10.9

Display a list of courses against departments ordered by the department name

SELECT course.title as coursetitle, department.name as departmentname
FROM course INNER JOIN department ON
course.departmentid = department.departmentid ORDER BY department.name