count the no. of employee in each department and fill the counting in respecting experience column
<p>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.</p>

<p>Output:</p>

<pre><code>dept    |0-5yrs|5-10yrs|10-15yrs
HR      |  4   |    9  |  0       
Account |  2   |    3  |  1
</code></pre>

<p>what I mean by the output is 4 employees in HR department have less than 5 years of experience and 9 people have more than 5 and less than 10 years of experience and 0 have 10-15 years of experience</p>