Error with the codes provided in the lectures
Thanks for reaching out and letting us know you encounter error code 1055 at this stage of the course.
We have addressed this issue later. Please refer to the following lecture and then retry running your queries. https://learn.365datascience.com/courses/sql/introduction-to-joins
Hope this helps.