Type the NOT IN anti-membership skeleton:

Answer

SELECT name FROM students WHERE student_id NOT IN ( SELECT student_id FROM registrations);

The inner SELECT returns one column of ids once; NOT IN keeps outer rows whose id is absent from that set — students who never registered (if any).