Find the job that was filled in the first half of 1990 and t

Find the job that was filled in the first half of 1990 and the same job that was filled during the same period in 1991. (Hint: use a SET operator for SQl.

Solution

Answer :

IT_PROG

Explanation :

Query :

         SELECT job_id

         FROM employess

         WHERE hire_date

         BETWEEN \'01-JAN-1990\' AND \'30-JUN-1990\'

         INTERSECT

         SELECT Job_id

         FROM employees

         WHERE hire_date BETWEEN \'01-JAN-1991\' AND \'30-JUN-1991\'