Is this solution okay-gives the same output
m.from_date as start_date
dept_manager m ON e.emp_no = m.emp_no
titles t ON e.emp_no = t.emp_no
where t.title = 'Manager'
1 answers ( 0 marked as helpful)
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.
Submit an answer
Why did you not do not null, primary key and auto increment for customer id in the solution?
Resolved: Queries with LIKE('Mar%') and LIKE('Mar_') are returning the output with 1000 rows each
I wrote this below code , but the output contained both M and F. I did not got the logic
does not rollback and i don't know what i have to do , i do all sug solution with no result