Grokking SQL for Tech Interviews
Ask Author
Back to course home

0% completed

32. Employee Department Exclusion (Easy)
Table of Contents

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

Problem Statement

Table: Employee
Each row in this table represents an individual employee, detailing their unique ID, name, and the department ID they belong to.

+---------------+---------+
| Column Name   | Type    | 
+---------------+---------+
| id            | int     | 
| name          | varchar |
| department_id | int     |
+---------------+---------+
id is the primary key for this table.
department_id refers to the ID of the department the employee works in.

Develop a solution to find the names of employees who do not work in a department with id = 3

.....

.....

.....

Like the course? Get enrolled and start learning!

Table of Contents

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible