From the faculty table, extract the year each faculty member joined from their doj (date of joining). Return the columns faculty_fname, faculty_lname, and the extracted year as join_year. Sort by join_year (ascending), then by faculty_lname (ascending).
Database schema
primary keyforeign keyarrow points to the referenced columndrag to pan