Join the students table with the departments table to show each student's full department name.
Return three columns: student_fname, student_lname, and department_name.
Order the rows by student_lname, then student_fname.
Database schema
primary keyforeign keyarrow points to the referenced columndrag to pan