Last answered:

03 Jan 2024

Posted on:

30 Dec 2023

0

i wrote another solution for this assigment which have the same result which the given answer

Another solution for this assigment which has the same result:

SELECT e.gender, COUNT(e.emp_no) AS number_manager
FROM employees e
JOIN titles t ON e.emp_no = t.emp_no
WHERE t.title = 'Manager'
GROUP BY e.gender;

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

03 Jan 2024

0

Hi Truong!
Thanks for reaching out.


Yes, this is also a valid solution. Bravo!


Hope this helps.
Best,
Tsvetelin

Submit an answer