<prompt> Kuandika SQL query kupata mshahara wa pili juu na jina la mfanyakazi wake. mshahara ni katika meza tofauti inayoitwa SALARIES na ni kushikamana kupitia FK kwa WATUMISHI.  <response>: Here is a SQL query that would find the second highest salary and employee name:SELECT e.employee_name, s.salaryFROM employees eJOIN salaries s ON e.id s.employee_idWHERE s.salary SELECT MAXs2.salary FROM salaries s2 WHERE s2.salary SELECT MAXs3.salary FROM salaries s3 ;This query joins the employees and salaries tables on the employee ID, and then uses a subquery to find the maximum salary that is less than the overall maximum salary, which will give us the second highest salary. The outer query then selects the employee name and salary for the corresponding employee with that salary. 