Another Solution
select gender, count(gender)
from dept_manager dm
join employees em
on dm.emp_no = em.emp_no
group by gender
1 answers ( 0 marked as helpful)
Hi Yahia!
Thanks for reaching out!
Yes, your solution is correct. When using JOIN(=INNER JOIN) the order of the tables does not matter. However, if using LEFT/RIGHT JOIN the order of the tables matters. Bravo!
Hope this helps.
Best,
Tsvetelin