w3resource
SQL exercises

SQL exercises on employee Database: List the id, name, salary, and experiences of all the employees working for the manger 68319

SQL employee Database: Exercise-28 with Solution

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

28. Write a query in SQL to list the id, name, salary, and experiences of all the employees working for the manger 68319.

Sample table: employees


Pictorial Presentation:

SQL exercises on employee Database: List the id, name, salary, and experiences of all the employees working for the manger 68319

Sample Solution:

SELECT emp_id,
       emp_name,
       salary,
       age(CURRENT_DATE, hire_date) "Experience"
FROM employees
WHERE manager_id=68319;

Sample Output:

 emp_id | emp_name | salary  |       Experience
--------+----------+---------+-------------------------
  66928 | BLAZE    | 2750.00 | 26 years 8 mons 29 days
  67832 | CLARE    | 2550.00 | 26 years 7 mons 21 days
  65646 | JONAS    | 2957.00 | 26 years 9 mons 28 days
(3 rows)

Practice Online


Sample Database: employee

employee database structure

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

Previous: Write a query in SQL to list all the employees joined on 1st may 91.
Next: Write a query in SQL to list the id, name, salary, and experience of all the employees who earn more than 100 as daily salary.

What is the difficulty level of this exercise?