SELECT s.studentid, s.name
FROM student s
INNER JOIN notes ON s.studentid = notes.studentid
WHERE (notes.note) <  "50"
ORDER BY student.name