SQL
---
select department.*
, coalesce(dptSlr.minSalary, 0.00) as minSalary
FROM `department`
left outer join
(SELECT employee.departmentId, MIN(employee.salary ) AS minSalary
FROM employee
GROUP BY employee.departmentId) dptSlr
on department.id = dptSlr.departmentId;