﻿ SQL exercises on employee Database: List the employee with their grade for the grade 4 - w3resource

SQL exercises on employee Database: List the employee with their grade for the grade 4

SQL employee Database: Exercise-64 with Solution

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

64. From the following tables, write a SQL query to find those employees whose grade is 4 and salary between minimum and maximum salary. Return all information of each employees and their grade and salary related details.

Pictorial Presentation:

Sample table: employees

Sample Solution:

``````SELECT *
FROM employees e,
WHERE e.salary BETWEEN s.min_sal AND s.max_sal
``````

Sample Output:

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

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.

What is the difficulty level of this exercise?

﻿