Question $17$

Not yet answered Marked out of $2\mathrm{.}00$

Which SQL query would retrieve the names of employees who work in the $\text{'}$HR$\text{'}$ department?

a$.$ None of the mentioned

b$.$ SELECT employee$\_$name FROM employees JOIN departments ON employees.department$\_$id $=$ departments.department$\_$id AND department$\_$name $=\text{'}$HR$\text{'}$;

c$.$ SELECT employee$\_$name FROM employees INNER JOIN departments ON employees.department$\_$id $=$ departments.department$\_$id WHERE department$\_$name $=\text{'}$HR$\text{'}$;

d$.$ SELECT employee$\_$name FROM employees WHERE department$\_$id $=($SELECT department$\_$id FROM departments WHERE department$\_$name $=\text{'}H{R}^{\text{'}})$;

e$.$ SELECT employee$\_$name FROM employees WHERE department$\_$name $=\text{'}$HR$\text{'}$;