The advisor table pairs each student (s_id) with an instructor (i_id). Join student, advisor and instructor to show each student together with the name of the instructor advising them.
Return two columns: the student's name as student_name and the advisor's name as advisor_name.
Order the rows by student_name.
Database schema
primary keyforeign keyarrow points to the referenced columndrag to pan