SQL · Question 7 · Medium

SQL question 7

Table Employee:
id | name | dept | salary
1 | Asha | HR | 30000
2 | Ravi | IT | 50000
3 | Neha | IT | 60000
4 | Karan | Sales | NULL
5 | Priya | HR | 45000
6 | Vikram | IT | 50000

Table Department:
dept_name | location
HR | Pune
IT | Bengaluru
Finance | Mumbai

How many rows does this query return?

SELECT d.dept_name, e.name
FROM Department d
LEFT JOIN Employee e ON d.dept_name = e.dept;
  1. 5
  2. 7
  3. 6
  4. 3
Answer and explanation

Answer: C. 6

Explanation: HR matches 2 employees and IT matches 3. Finance has no match, but a LEFT JOIN keeps it once with NULL for name. 2 + 3 + 1 = 6 rows. Karan (Sales) is dropped because Sales is not in Department.

Previous: Table Employee: id | name | dept | salary 1 | Asha | HR | 30000 2 | Ravi | IT… · Next: Table Employee: id | name | dept | salary 1 | Asha | HR | 30000 2 | Ravi | IT…

Practise sql

Try a fresh set of sql questions with an explanation after every answer, free and without signing up: SQL practice. Or sit a full placement mock test.

More sql questions

More technical & programming practice

Operating Systems · Computer Networks · Software Engineering · Cloud & DevOps · GenAI Basics · Pseudo-code · C Programming · Java

LogicWiz Exams home · All practice topics · Placement mock tests · Daily 10 challenge