Resolved: Where clause in the assignment.
Why do we have to use a where caluse in the query to filter only managers? Since we are using inner join between managers table and other tables the query should by defualt give values only for managers right !
1 answers ( 1 marked as helpful)
Hi Barun!
Thanks for reaching out.
Actually, this is a very good question. Bravo!
This is because some of these managers which are presented in the dept_manager table have worked other positions like Staff and Senior Staff. This is why we need to use the WHERE clause in order to filter only the title Manager. You can check the same query without the WHERE clause and you will obtain 54 rows.
Hope this helps.
Best,
Tsvetelin