At around 85% completion of ‘Build a Student Database: Part 2’, the following question might have incorrect answers that is accepted and prompted in the hint section.
Question (no issues here):
You’re doing great. Next, use the most efficient ‘JOIN’ to join the tables you would need if you were asked to get the first name, last name, major, and GPA of students who are taking Data Science or have a gpa of 3.8 or greater. Only join the tables for now, don’t use any other conditions.
My solution (rejected, according to me this prints exactly what is demanded in the question, not one column or row more):
select first_name,last_name,major,gpa from students left join majors on students.major_id=majors.major_id where major=‘Data Science’ or gpa>=3.8;
Solution prompted in hint and accepted:
select * from students left join majors on students.major_id=majors.major_id;