problem 1 alternate solve
can't we use the following query to solve the problem 1
1 answers ( 0 marked as helpful)
Hi Jubair!
Thanks for reaching out.
We need to use the dept_emp table because we use the from_date column from this table. We need to join the tables t_employees and t_dept_emp. Also, we should use the HAVING clause, because we want the result set to contain years after 1990. Please, use the solution.
Hope this helps.
Best,
Tsvetelin
Submit an answer
