Last answered:

25 Oct 2021

Posted on:

02 Jul 2021


Resolved: Please I need clarification here

Please I need clarification here, how come the "where" clause came after "group by" as it should be before it and if we need to use aggregate function at that place after "group by" so we can use "having" clause, please correct me if I'm wrong

2 answers ( 1 marked as helpful)
Posted on:

05 Jul 2021


Oh very nice catch! I didn't actually notice that but you're 100% right. Where should come before group by and having comes after. I will make a note of this in the lecture.

Posted on:

25 Oct 2021


thank you for a detailed way to break down a complex question up to final query, really helpfull

Submit an answer