Which query will return only students who have a department assigned and that department exists in the departments table?

Question

Answer

a.  SELECT name, department_name 
 FROM students 
 INNER JOIN departments  
   ON students.department_id = departments.department_id;

Answer

c.  SELECT name, department_name 
 FROM students 
 RIGHT JOIN departments  
   ON students.department_id = departments.department_id;

Answer

b.  SELECT name, department_name 
 FROM students 
 WHERE department_id IS NOT NULL;

Answer

d.  SELECT name, department_name 
 FROM students 
 LEFT JOIN departments  
   ON students.department_id = departments.department_id;

Crowdly