Problem with Join and Group By
I am typing the query same as the lecture but this is showing me problem in my Group by statement. I hope to hear from you soon. I have provided the query and the error Screenshot below.

2 answers ( 0 marked as helpful)
Whoever has the same problem and is reading this. After finding a bit, I found the solution in one of the comments. Kindly see that. I am not understanding technicality of the solution but after finishing Advance SQL, I should be able to hopefully. https://365datascience.com/q/22ff318385
Hi Keyur!
Thanks for reaching out.
I am glad that you have resolved your issue! After learning some new topics you will be able to understand the technical reason behind this solution.
Best,
Tsvetelin