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
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.