10. Which MONTH (i.e. JAN or FEB, or JUN, etc…) in the hiring date of all employ

Question

10. Which MONTH (i.e. JAN or FEB, or JUN, etc…) in the hiring date of all employees across all departments can be found in all three departments in the employees table (dept 50, 60, 80)? Hint: the month of JANUARY is a month where employees were hired into departments 50 and 60 and 80.

The data in the table maybe something like this

Hiredate Department_id

29-JAN-97 50   

03-JAN-90 60

29-JAN-00 80

The output of the SQL you would write should produce something like the following:

Month Name

------------------

January

Explanation / Answer

SELECT DISTINCT TO_CHAR(Hiredate, 'Month') Month_Name,Department_id FROM EMPLOYEES WHERE department_id IN (50, 60, 80);

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.