SELECT `department_id`,
    (SELECT DISTINCT `e2`.`salary`
        FROM `employees` AS `e2`
        WHERE `e2`.`department_id` = `e1`.`department_id`
        ORDER BY `e2`.`salary` DESC
        LIMIT 2, 1) AS `third_highest_salary`
FROM `employees` AS `e1`
GROUP BY `department_id`
HAVING `third_highest_salary` IS NOT NULL
ORDER BY `department_id`;