SELECT DISTINCT st.id_student, name,surname
FROM students st
INNER JOIN exams ex
ON ex.id_student=st.id_student
WHERE passed = 'N'
ORDER BY 3 DESC;