SQL Exercise: List the employees with annual salaries in a ranges

SQL employee Database: Exercise-44 with Solution

[An editor is available at the bottom of the page to write and execute the scripts.]

44. From the following table, write a SQL query to search for all employees with an annual salary between 24000 and 50000 (Begin and end values are included.). Return complete information about the employees.

Sample table: employees

Pictorial Presentation:

Sample Solution:

SELECT *
FROM employees
WHERE 12*salary BETWEEN 24000 AND 50000;

Sample Output:

 emp_id | emp_name | job_name | manager_id | hire_date  | salary  | commission | dep_id
--------+----------+----------+------------+------------+---------+------------+--------
  66928 | BLAZE    | MANAGER  |      68319 | 1991-05-01 | 2750.00 |            |   3001
  67832 | CLARE    | MANAGER  |      68319 | 1991-06-09 | 2550.00 |            |   1001
  65646 | JONAS    | MANAGER  |      68319 | 1991-04-02 | 2957.00 |            |   2001
  67858 | SCARLET  | ANALYST  |      65646 | 1997-04-19 | 3100.00 |            |   2001
  69062 | FRANK    | ANALYST  |      65646 | 1991-12-03 | 3100.00 |            |   2001
(5 rows)

Explanation:

The provided query in SQL that selects all columns and rows from the 'employees' table where the result of multiplying the "salary" column by 12 falls between 24000 and 50000.

The WHERE clause includes those employees whose annual salary is between 24,000 and 50,000.

The BETWEEN operator filters the rows of a range of annual salaries which is inclusive, so that the employees whose annual salary is exactly 24,000 or 50,000 would be included in the results.

Relational Algebra Expression:

Relational Algebra Tree:

Practice Online

Sample Database: employee

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

Previous SQL Exercise: List the employees who joined in June 1991.
Next SQL Exercise: Employees who joined on the given days in the year 1991