SQL exercises on employee Database: List the name, job name, department, salary, and grade of the employees according to the department in ascending order
SQL employee Database: Exercise-84 with Solution
[An editor is available at the bottom of the page to write and execute the scripts.]
84. From the following table, write a SQL query to find the employees according to the department in ascending order. Return name, job name, department, salary, and grade.
Sample table: employees
Sample table: department
Sample table: salary_grade
SELECT e.emp_name, e.job_name, d.dep_name, e.salary, s.grade FROM employees e, department d, salary_grade s WHERE e.dep_id = d.dep_id AND e.salary BETWEEN s.min_sal AND s.max_sal ORDER BY e.dep_id ;
emp_name | job_name | dep_name | salary | grade ----------+-----------+-----------+---------+------- KAYLING | PRESIDENT | FINANCE | 6000.00 | 5 CLARE | MANAGER | FINANCE | 2550.00 | 4 MARKER | CLERK | FINANCE | 1400.00 | 2 SANDRINE | CLERK | AUDIT | 900.00 | 1 SCARLET | ANALYST | AUDIT | 3100.00 | 4 ADNRES | CLERK | AUDIT | 1200.00 | 1 FRANK | ANALYST | AUDIT | 3100.00 | 4 JONAS | MANAGER | AUDIT | 2957.00 | 4 BLAZE | MANAGER | MARKETING | 2750.00 | 4 JULIUS | CLERK | MARKETING | 1050.00 | 1 ADELYN | SALESMAN | MARKETING | 1700.00 | 3 WADE | SALESMAN | MARKETING | 1350.00 | 2 MADDEN | SALESMAN | MARKETING | 1350.00 | 2 TUCKER | SALESMAN | MARKETING | 1600.00 | 3 (14 rows)
Sample Database: employee
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous: From the following tables, write a SQL query to find the employees along with grades in ascending order. Return complete information about the employees.
Next: From the following tables, write a SQL query to find all employees except CLERK and sort the result-set in descending order by salary. Return employee name, job name, salary, grade and department name.
What is the difficulty level of this exercise?
- New Content published on w3resource:
- Scala Programming Exercises, Practice, Solution
- Python Itertools exercises
- Python Numpy exercises
- Python GeoPy Package exercises
- Python Pandas exercises
- Python nltk exercises
- Python BeautifulSoup exercises
- Form Template
- Composer - PHP Package Manager
- PHPUnit - PHP Testing
- Laravel - PHP Framework