SQL Question 2: (LEFT JOIN)
Given two tables, students and students_marks, both containing student_id (primary key), student_name and students_marks tables contains marks. Display students who never appeared for exam.

Question

Anonymous · Accepted Answer

SELECT 
    st.student_id
    st.student_name
FROM
students AS st 
LEFT JOIN students_marks AS sm
ON st.student_id = sm.student_id
WHERE sm.student_id IS NULL

Vermont Information Processing

Vermont Information Processing Interview Question

Interview Answer

Want the inside scoop on your own company?

Bowls

Followed companies

Job searches