w3resource

SQL exercises on employee Database: List the employee id, name, annual salary, daily salary of all the employees in the ascending order of annual salary who works as a SALESMAN

SQL employee Database: Exercise-79 with Solution

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

79. From the following table, write a SQL query to list the employees who works as a SALESMAN. Sort the result set in ascending order of annual salary. Return employee id, name, annual salary, daily salary of all the employees.

Pictorial Presentation:

SQL exercises on employee Database: List the employee id, name, annual salary, daily salary of all the employees in the ascending order of annual salary who works as a SALESMAN

Sample table: employees


Sample Solution:

SELECT e.emp_id,
       e.emp_name,
       12*salary "Annual Salary",
       (12*salary)/365 "Daily Salary"
FROM employees e
WHERE e.job_name = 'SALESMAN'
ORDER BY "Annual Salary" ASC;

Sample Output:

 emp_id | emp_name | Annual Salary |    Daily Salary
--------+----------+---------------+---------------------
  65271 | WADE     |      16200.00 | 44.3835616438356164
  66564 | MADDEN   |      16200.00 | 44.3835616438356164
  68454 | TUCKER   |      19200.00 | 52.6027397260273973
  64989 | ADELYN   |      20400.00 | 55.8904109589041096
(4 rows)

Practice Online


Sample Database: employee

employee database structure

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

Previous: From the following table, write a SQL query to find the employees whose annual salary is below 25000. Sort the result set in ascending order of the salary. Return complete information about the employees.
Next: From the following table, write a SQL query to list the employee ID, name, hire date, current date and experience of the employees in ascending order on their experiences.

What is the difficulty level of this exercise?