SQLite Exercise: Display the names and department ID of all employees in departments 30 or 100 in ascending alphabetical order by department ID

Write a query to display the names (first_name, last_name) and department ID of all employees in departments 30 or 100 in ascending alphabetical order by department ID.

Sample table : employees

SQLite Code :

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

Output:

first_name  last_name   department_id
----------  ----------  -------------
Den         Raphaely    30
Alexander   Khoo        30
Shelli      Baida       30
Sigal       Tobias      30
Guy         Himuro      30
Karen       Colmenares  30
Nancy       Greenberg   100
Daniel      Faviet      100
John        Chen        100
Ismael      Sciarra     100
Jose Manue  Urman       100
Luis        Popp        100

Relational Algebra Expression:

Relational Algebra Tree:

Practice SQLite Online

Model Database

Structure of 'hr' database :

Improve this sample solution and post your code through Disqus.

Previous: Write a query to display the names (first_name, last_name) and salary for all employees whose salary is not in the range $10,000 through $15,000.
Next: Write a query to display the names (first_name, last_name) and salary for all employees whose salary is not in the range $10,000 through $15,000 and are in department 30 or 100.