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