w3resource

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. From the following table, write a SQL query to find those employees who were hired during November 5th, 2007 and July 5th, 2009. Return full name (first and last), job id and hire date.

Sample table : employees


Sample Solution:

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';

Sample Output:

    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)

Practice Online


HR database model

Query Visualization:

Duration:

Query visualization of Display the full name, job id and date of hire for those employees who was hired during November 5th, 2007 and July 5th, 2009 - Duration

Rows:

Query visualization of Display the full name, job id and date of hire for those employees who was hired during November 5th, 2007 and July 5th, 2009 - Rows

Cost:

Query visualization of Display the full name, job id and date of hire for those employees who was hired during November 5th, 2007 and July 5th, 2009 - Cost

Contribute your code and comments through Disqus.

Previous: From the following table, write a SQL query to find those employees whose salary is not in the range 7000 and 15000 (Begin and end values are included). Sort the result-set in ascending order by the full name (first and last). Return full name and salary.
Next: From the following table, write a SQL query to find those employees who works either in department 70 or 90. Return full name (first and last name), department id.

Test your Programming skills with w3resource's quiz.

What is the difficulty level of this exercise?



SQL: Tips of the Day

MySQL export schema without data

mysqldump -h yourhostnameorIP -u root -p --no-data dbname > schema.sql

Ref: https://bit.ly/3xzB9dS