SQL SORTING and FILTERING on HR Database: Display the full name, job id and date of hire for those employees who was hired during November 5th, 2007 and July 5th, 2009
SQL SORTING and FILTERING on HR Database: Exercise-12 with Solution
12. Write a query in SQL to display the full name (first and last), job id and date of hire for those employees who was hired during November 5th, 2007 and July 5th, 2009.
Sample table : employees
SELECT first_name ||' '||last_name AS Full_Name, job_id, hire_date FROM employees WHERE hire_date BETWEEN '2007-11-05' AND '2009-07-05';
full_name | job_id | hire_date ------------------+------------+------------ Luis Popp | FI_ACCOUNT | 2007-12-07 Kevin Mourgos | ST_MAN | 2007-11-16 Steven Markle | ST_CLERK | 2008-03-08 Ki Gee | ST_CLERK | 2007-12-12 Hazel Philtanker | ST_CLERK | 2008-02-06 Eleni Zlotkey | SA_MAN | 2008-01-29 Oliver Tuvault | SA_REP | 2007-11-23 Mattea Marvins | SA_REP | 2008-01-24 David Lee | SA_REP | 2008-02-23 Sundar Ande | SA_REP | 2008-03-24 Amit Banda | SA_REP | 2008-04-21 Sundita Kumar | SA_REP | 2008-04-21 Charles Johnson | SA_REP | 2008-01-04 Girard Geoni | SH_CLERK | 2008-02-03 Randall Perkins | SH_CLERK | 2007-12-19 Douglas Grant | SH_CLERK | 2008-01-13 (16 rows)
Contribute your code and comments through Disqus.
Previous: Write a query in SQL to display the full name (first and last) name, and salary, for all employees whose salary is out of the range 7000 and 15000 and make the result set in ascending order by the full name.
Next: Write a query in SQL to display the the full name (first and last name), and department number for those employees who works either in department 70 or 90.
What is the difficulty level of this exercise?