Create a view employee_directory with emp_id, full_name (first + space + last) and dept_name. Employees without a department should still appear (with an empty department).
Tables
departments
dept_idinteger
dept_namevarchar
locationvarchar
emp_projects
emp_idinteger
project_idinteger
rolevarchar
hours_per_weekinteger
employees
emp_idinteger
first_namevarchar
last_namevarchar
emailvarchar
dept_idinteger
manager_idinteger
job_titlevarchar
salaryinteger
hire_datedate
cityvarchar
gendervarchar
projects
project_idinteger
project_namevarchar
dept_idinteger
budgetinteger
start_datedate
end_datedate
Hints(0/2)
Solution
Unlocks after you solve it or after 3 submissions
SQL (DuckDB)
Ctrl + Enter to runLog in to save progress and earn XP