SQL SORTING and FILTERING on HR Database: Write a query in SQL to display the full name, phone number with email jointly, and salary, for employees whose salary is within 9000 and 17000

SQL SORTING and FILTERING on HR Database: Exercise-9 with Solution

9. Write a query in SQL to display the full name (first and last), the phone number and email separated by hyphen, and salary, for those employees whose salary is within the range of 9000 and 17000. The column headings assign with Full_Name, Contact_Details and Remuneration respectively.

Sample table : employees

Sample Solution:

SELECT first_name ||' '||last_name AS Full_Name,
       phone_number ||' - '|| email AS Contact_Details,
       salary  AS Remuneration
         FROM employees
           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)

Practice Online

Query Visualization:

Duration:

Rows:

Cost:

Contribute your code and comments through Disqus.

Previous: Write a query in SQL to display the full name (first and last name), and salary for all employees who does not earn any commission.
Next: Write a query in SQL to display the first and last name, and salary for those employees whose first name is ending with the letter m.