Stuck on Building a Student Database: Part 2

Backend Development
1

Hi there, I’ve been following the databases course for a while, and now I’m stuck on this step:
“You also don’t want any duplicates. Use DISTINCT to only return the unique ones to see the list of majors who have students.”

The hint says:
The previous query was SELECT major FROM students INNER JOIN majors ON students.major_id = majors.major_id;

And indeed, that is the query from the previous step. So I think the query for the current step should be:
SELECT DISTINCT major FROM students INNER JOIN majors ON students.major_id = majors.major_id;

For some reason, this one is not being accepted. Am I doing something wrong?

2

If you click hint again do you get any additional information?

3

I totally forgot there could be more hints for something so simple, thank you!
The query expected by the step is:
SELECT DISTINCT(major) FROM students INNER JOIN majors ON students.major_id = majors.major_id;

4

Those pesky brackets. I always forget them too.