Last answered:

22 Aug 2022

Posted on:

16 Aug 2022

0

problem 1 alternate solve

can't we use the following query to solve the problem 1image

1 answers ( 0 marked as helpful)
Instructor
Posted on:

22 Aug 2022

0

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