My friend asked me how to create following SQL query: For each employee hired before 1992, display the employee’s last…