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)
Hi Truong!
Thanks for reaching out.
Yes, this is also a valid solution. Bravo!
Hope this helps.
Best,
Tsvetelin
Submit an answer
related questions
Resolved:
Getting Null as the result from all stored procedure queries including the assignment too.