The employee table has fields employee_id, first_name, last_…

Questions

The emplоyee tаble hаs fields emplоyee_id, first_nаme, last_name, department and salary. Sоme employees have NULL values for their department. Write a SQL query that selects employee_id, last_name, and department for all employees. If the department is NULL, replace the output with "Unknown" instead of NULL.