title: How to get name of the emp whose salary is gretear than average salary of depatment in HIVE
body: <pre><code>Dept_id  Emp_name  Sal
  1        amit      2500 
  2        neha      3600
  3        ankit     4500
  </code></pre>
  
  <p>Need to find the name of employee whose salary is greater than average salary of the whole department. using hive.</p>