A database table is defined as interns(intern_id, name, mentor_id), and interns who have not yet been assigned a mentor have NULL stored in the mentor_id column. Which of the following SQL queries correctly returns the names of all interns who have no mentor assigned?
SELECT name FROM interns WHERE mentor_id IS NULL;
SELECT name FROM interns WHERE mentor_id = NULL;
SELECT name FROM interns WHERE mentor_id != NULL;
SELECT name FROM interns WHERE mentor_id = 0;
The verified answer and full solution are one login away
Every answer here is machine verified, with a step-by-step solution that teaches the method. Your login also unlocks a 7-question mock preview in the real exam interface.
Log in to see the answerMore sql questions