maybe this cud help!!! in the query below, the count of employees who joined during the week will be displayed.

select trunc(hiredate,'WW'),count(*) from emp
group by trunc(hiredate,'WW')