count the no. of employee group by department and fill the counting in respecting experience column : I have two tables employee and department,Employee table schema(Eid,Ename,DOJ,Sal,Dept ID) and Department schema(Dept id,Dname).So what i want  in output is count the no. of employee by each department and according to experience.

O/P->
dept       0-5yrs    5-10yrs   10-15yrs above15yrs
HR           4          9
Account      2          3        1

like this..