L1 Q3
Beginner Level
Practice Question
Level 1 - Question 3: List Employees from HR Department
Scenario
As part of the HR audit, the company needs a list of employees who belong to the "HR" department.
Task
Write a query to display all details of employees who work in the HR department.
Sample Schema: employees
| emp_id | name | department | designation | salary |
|---|---|---|---|---|
| 201 | Sara Malik | HR | HR Manager | 8000 |
| 202 | Reza Karim | IT | Software Engineer | 9500 |
| 203 | Nadia Islam | HR | Recruiter | 6000 |