← Quiz: SQL Joins: all 10 questions
Quiz: SQL Joins · Question 6 of 10
How many rows does departments LEFT JOIN employees ON e.deptid = d.deptid return for the company tables?
How many rows does departments LEFT JOIN employees ON e.dept_id = d.dept_id return for the company tables?
- A.4
- B.6
- C.7
- D.28
Answer & explanation
Correct answer: 7
6 matched employees plus one row for Marketing with NULL employee columns. Arjun is not included because departments is the left table.
Can you get the rest right without peeking?
Take the timed Quiz: SQL Joins quiz free. Pass it to earn XP and count towards your certificate.
Start the quiz →