Error while trying to replicate within-lecture-code

Got the same error, tried resolving it by deleting ONLY_FULL_GROUP_BY option from server options file, but for some reason couldn't apply changes to the file. Then i solved the problem by simply stating every statement from SELECT part into GROUP BY

Hi Saeed and Miro!

Thanks for reaching out.

Please accept my apologies for the delayed response.

@Miro: Thank you very much for sharing your solution with the Community !

@Saeed: Since programming is an area where multiple components of different type are necessary to be taken into account simultaneously, we believe there is value in not presenting all of it altogether but at the right moment throughout the course syllabus. That said, we discuss how to prevent error 1055 in the resources section of the following lecture: https://learn.365datascience.com/courses/sql/join-and-where-used-together/

Please refer to it for an explanation.

Hope this helps.
Best,
Martin