﻿ PostgreSQL Restricting and Sorting Data: Display the employees who work in the department 30 or 100 and arrange the result in ascending order on the department ID - w3resource

# PostgreSQL Restricting and Sorting Data: Display the employees who work in the department 30 or 100 and arrange the result in ascending order on the department ID

2. Write a query to display the name, including first_name and last_name, and department ID who works in the department 30 or 100 and arrange the result in ascending order according to the department ID.

Sample Solution:

Code:

SELECT first_name, last_name, department_id
FROM employees
WHERE department_id IN (30, 100)
ORDER BY  department_id  ASC;

Sample table: employees

Output:

pg_exercises=# SELECT first_name, last_name, department_id
pg_exercises-# FROM employees
pg_exercises-# WHERE department_id IN (30, 100)
pg_exercises-# ORDER BY  department_id  ASC;

first_name  | last_name  | department_id
-------------+------------+---------------
Karen       | Colmenares |            30
Den         | Raphaely   |            30
Alexander   | Khoo       |            30
Shelli      | Baida      |            30
Sigal       | Tobias     |            30
Guy         | Himuro     |            30
Nancy       | Greenberg  |           100
Daniel      | Faviet     |           100
John        | Chen       |           100
Ismael      | Sciarra    |           100
Jose Manuel | Urman      |           100
Luis        | Popp       |           100
(12 rows)

Relational Algebra Expression:

Relational Algebra Tree:

## Practice Online

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

What is the difficulty level of this exercise?

﻿