Resolved: Trying another solution
This was the query I came up with before checking the solution provided can you tell me where did i go wrong or if this approach is not even valid 
2 answers ( 1 marked as helpful)
Hi Abdelrahman!
Thanks for reaching out.
Your code has correct syntax. But the idea is to count the dm.emp_no column and group by the gender column. You do not need to specify a condition in the COUNT() function because Workbench does not read it.
Hope this helps.
Best,
Tsvetelin
thank you this was helpful, what other functions SQL doesn't read the conditions written in them from what we learned