title: How can I get all employees with a salary less than the average salary?
body: <p>I can get the count of employees and avg salary but when I try to get the the addition select of listing the number of employees paid below the average it fails.</p>
  
  <pre><code>select count(employee_id),avg(salary) 
  from employees
  Where salary &lt; avg(salary);
  </code></pre>