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
SELECT emp_id, emp_name, salary, age(CURRENT_DATE, hire_date) "Experience" FROM employees WHERE manager_id=68319;
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)
Sample Database: employee
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?
- New Content published on w3resource :
- 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