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

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.

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

Follow this topic

Peter Salib

Last answered:

25 Oct 2021

Posted on:

02 Jul 2021

Resolved: Please I need clarification here

in SQL for Data Science Interviews / Mock Interview 9

2 answers ( 1 marked as helpful)

Tina Huang

Instructor

Posted on:

05 Jul 2021

Helpful answer

CALVIN NDUNDUMA

Posted on:

25 Oct 2021

Resolved: Please I need clarification here

Submit an answer

related questions