Concatenate name with department using IFNULL for missing dept.
Toolliyo Coach
Progressive help: Nudge → Guide → Approach. Full solution stays behind the Solution tab.
Editor is open — no login wall to practice.
| Test | Status | Details |
|---|
Ready — edit the code above and click Run or Submit.
-- MySQL schema
CREATE TABLE employees (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(100), dept_id INT, salary DECIMAL(10,2));
CREATE TABLE departments (id INT PRIMARY KEY, name VARCHAR(50));
INSERT INTO employees (name, dept_id, salary) VALUES ('Ali',1,90000),('Sara',2,120000);
INSERT INTO departments VALUES (1,'Engineering'),(2,'Sales');
SELECT CONCAT(e.name, ' - ', IFNULL(d.name, 'Unknown')) AS label
FROM employees e
LEFT JOIN departments d ON e.dept_id = d.id;Prefer Coach (Nudge → Guide → Approach) before revealing. No forced signup.
IFNULL and CONCAT are common MySQL interview functions.
Sign in to save and review your submission history. You can still Run code on the Editor tab as a guest.
Sign in