Learn SQL by Building a Student Database: Part 2


I’ve been doing this course this morning and I find the part about joins misleading. There was a task that asked for a left join that was repeated but with an added condition in the next step. However, in the hints(and the answer itself) the join was reversed to a right one and the tables were switched respectively. Similar thing happened at least twice so far. Could you please have a look at it as it should corrected. I did what the hints told me to do but basically the hints were contradicting the original task. Unfortunately, I can’t provide the exact number of the steps where this happened but I can tell you that it happened around the 82-84 percent of completion of the course. I hope I managed to express myself clearly. Let me know if you have any further questions. Thanks