SELECT
  employees.emp_no,
  employees.first_name,
  employees.last_name,
  first_salary_detailed.salary,
  first_salary_detailed.from_date,
  first_salary_detailed.to_date
FROM
  employees
  JOIN(
    SELECT
      salaries.emp_no emp_no, salaries.salary salary, salaries.from_date from_date, salaries.to_date to_date
    FROM
      salaries JOIN(
        SELECT
          salaries.emp_no as emp_no,
          MIN(salaries.to_date) as first_salary_to_date
        FROM
          salaries
        GROUP BY
          emp_no
      ) AS first_salary ON (salaries.emp_no =  first_salary.emp_no AND salaries.to_date = first_salary.first_salary_to_date)
  ) AS first_salary_detailed ON (first_salary_detailed.emp_no = employees.emp_no)
WHERE
    employees.first_name = 'Noel';