SQL Exercise: Find employees whose salary is within 9000 to 17000

Last update on January 08 2026 12:47:59 (UTC/GMT +8 hours)

9. From the following table, write a SQL query to find the employees whose salary is in the range 9000,17000 (Begin and end values are included). Return full name, contact details and salary.

Sample table: employees

+-------------+-------------+-------------+----------+--------------------+------------+------------+----------+----------------+------------+---------------+
| EMPLOYEE_ID | FIRST_NAME  | LAST_NAME   | EMAIL    | PHONE_NUMBER       | HIRE_DATE  | JOB_ID     | SALARY   | COMMISSION_PCT | MANAGER_ID | DEPARTMENT_ID |
+-------------+-------------+-------------+----------+--------------------+------------+------------+----------+----------------+------------+---------------+
|         100 | Steven      | King        | SKING    | 515.123.4567       | 2003-06-17 | AD_PRES    | 24000.00 |           0.00 |          0 |            90 |
|         101 | Neena       | Kochhar     | NKOCHHAR | 515.123.4568       | 2005-09-21 | AD_VP      | 17000.00 |           0.00 |        100 |            90 |
|         102 | Lex         | De Haan     | LDEHAAN  | 515.123.4569       | 2001-01-13 | AD_VP      | 17000.00 |           0.00 |        100 |            90 |
|         103 | Alexander   | Hunold      | AHUNOLD  | 590.423.4567       | 2006-01-03 | IT_PROG    |  9000.00 |           0.00 |        102 |            60 |
|         104 | Bruce       | Ernst       | BERNST   | 590.423.4568       | 2007-05-21 | IT_PROG    |  6000.00 |           0.00 |        103 |            60 |
|         105 | David       | Austin      | DAUSTIN  | 590.423.4569       | 2005-06-25 | IT_PROG    |  4800.00 |           0.00 |        103 |            60 |
|         106 | Valli       | Pataballa   | VPATABAL | 590.423.4560       | 2006-02-05 | IT_PROG    |  4800.00 |           0.00 |        103 |            60 |
|         107 | Diana       | Lorentz     | DLORENTZ | 590.423.5567       | 2007-02-07 | IT_PROG    |  4200.00 |           0.00 |        103 |            60 |
|         108 | Nancy       | Greenberg   | NGREENBE | 515.124.4569       | 2002-08-17 | FI_MGR     | 12008.00 |           0.00 |        101 |           100 |
|         109 | Daniel      | Faviet      | DFAVIET  | 515.124.4169       | 2002-08-16 | FI_ACCOUNT |  9000.00 |           0.00 |        108 |           100 |
......
|         206 | William     | Gietz       | WGIETZ   | 515.123.8181       | 2002-06-07 | AC_ACCOUNT |  8300.00 |           0.00 |        205 |           110 |
+-------------+-------------+-------------+----------+--------------------+------------+------------+----------+----------------+------------+---------------+

View the table

Sample Solution:

-- Selecting a concatenated string of 'first_name' and 'last_name' as 'Full_Name',
-- a concatenated string of 'phone_number' and 'email' as 'Contact_Details',
-- and the 'salary' column as 'Remuneration' from the 'employees' table
SELECT first_name || ' ' || last_name AS Full_Name,
       phone_number || ' - ' || email AS Contact_Details,
       salary AS Remuneration
-- Specifying the table to retrieve data from ('employees')
FROM employees
-- Filtering the results based on the condition that 'salary' is between 9000 and 17000
WHERE salary BETWEEN 9000 AND 17000;

Sample Output:

     full_name     |        contact_details        | remuneration
-------------------+-------------------------------+--------------
 Neena Kochhar     | 515.123.4568 - NKOCHHAR       |     17000.00
 Lex De Haan       | 515.123.4569 - LDEHAAN        |     17000.00
 Alexander Hunold  | 590.423.4567 - AHUNOLD        |      9000.00
 Nancy Greenberg   | 515.124.4569 - NGREENBE       |     12000.00
 Daniel Faviet     | 515.124.4169 - DFAVIET        |      9000.00
 Den Raphaely      | 515.127.4561 - DRAPHEAL       |     11000.00
 John Russell      | 011.44.1344.429268 - JRUSSEL  |     14000.00
 Karen Partners    | 011.44.1344.467268 - KPARTNER |     13500.00
 Alberto Errazuriz | 011.44.1344.429278 - AERRAZUR |     12000.00
 Gerald Cambrault  | 011.44.1344.619268 - GCAMBRAU |     11000.00
 Eleni Zlotkey     | 011.44.1344.429018 - EZLOTKEY |     10500.00
 Peter Tucker      | 011.44.1344.129268 - PTUCKER  |     10000.00
 David Bernstein   | 011.44.1344.345268 - DBERNSTE |      9500.00
 Peter Hall        | 011.44.1344.478968 - PHALL    |      9000.00
 Janette King      | 011.44.1345.429268 - JKING    |     10000.00
 Patrick Sully     | 011.44.1345.929268 - PSULLY   |      9500.00
 Allan McEwen      | 011.44.1345.829268 - AMCEWEN  |      9000.00
 Clara Vishney     | 011.44.1346.129268 - CVISHNEY |     10500.00
 Danielle Greene   | 011.44.1346.229268 - DGREENE  |      9500.00
 Lisa Ozer         | 011.44.1343.929268 - LOZER    |     11500.00
 Harrison Bloom    | 011.44.1343.829268 - HBLOOM   |     10000.00
 Tayler Fox        | 011.44.1343.729268 - TFOX     |      9600.00
 Ellen Abel        | 011.44.1644.429267 - EABEL    |     11000.00
 Michael Hartstein | 515.123.5555 - MHARTSTE       |     13000.00
 Hermann Baer      | 515.123.8888 - HBAER          |     10000.00
 Shelley Higgins   | 515.123.8080 - SHIGGINS       |     12000.00
(26 rows)

Code Explanation:

The said query in SQL that retrieves the first name, last name concatenated as "Full_Name", phone number, and email concatenated as "Contact_Details", and salary as "Remuneration" from the 'employees' table where the salary is between 9000 and 17000.

Go to:

PREV : Employees who does not earn any commission.
NEXT : Employees whose first name is ending with the letter m.

Practice Online