Last answered:

11 Nov 2022

Posted on:

10 Nov 2022

0

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 image

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

11 Nov 2022

0

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

Posted on:

11 Nov 2022

0

thank you this was helpful, what other functions SQL doesn't read the conditions written in them from what we learned

Submit an answer