This query gives us the name and major, but not the year, of all students that are in their first year.

Make sure to pick SELECT name, major, followed by WHERE year = 1.