Tell us what’s happening:
I was close to the end, where the problem was “List of unique courses, in reverse alphabetical order, that no student or ‘Obie Hilpert’ is taking:”
I tried students LEFT JOIN majors LEFT JOIN majors_courses FULL JOIN courses, but it was not successful. I had to use 3 FULL JOINS to get the solution, but I found this would count a course that have students in a major but not in another. (e.g. Python)
Did I misunderstand the problem? Did it consider a course from different majors to be unique? Thx
Your code so far
Your browser information:
User Agent is: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36 Edg/149.0.0.0
Challenge Information:
Build a Student Database: Part 2 - Build a Student Database: Part 2