This is a SQL problem. Show the Month and day that an employee got hired on alon

Question

This is a SQL problem.

Show the Month and day that an employee got hired on along with the count of how many employees in the emp table got hired on the same day and month all hiredates where we hired EXACTLY two employees on the same day of the same month irrespective of the year. Sample output:

dd-Mon

# Hired Employee

13 Jan

2

29 Jan

2

30 Jan

2

07 Feb

2

10 Mar

2

19 Mar

2

10 Apr

2

21 Apr

2

21 Jun

2

17 Aug

2

20 Aug

2

28 Sep

2

07 Dec

2

dd-Mon

# Hired Employee

13 Jan

2

29 Jan

2

30 Jan

2

07 Feb

2

10 Mar

2

19 Mar

2

10 Apr

2

21 Apr

2

21 Jun

2

17 Aug

2

20 Aug

2

28 Sep

2

07 Dec

2

Explanation / Answer

select to_char(hiredate,'fmdd Mon') as dd-Mon ,count(*)

from emp

group by hiredate

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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