Is this solution okay-gives the same output
SELECT
e.first_name,
e.last_name,
e.hire_date,
t.title,
m.from_date as start_date
FROM
employees e
JOIN
dept_manager m ON e.emp_no = m.emp_no
JOIN
titles t ON e.emp_no = t.emp_no
where t.title = 'Manager'
;
1 answers ( 0 marked as helpful)
Hi Awshesh!
Thanks for reaching out.
Yes, this solution works also. You used the titles table and in the WHERE clause you used the needed filter for managers.
Hope this helps.
Best,
Tsvetelin
Submit an answer
