Could you show me a list of employees with a salary less than the average?
SELECT name FROM Employee WHERE salary  <   ( SELECT avg ( salary )  FROM Employee ) 
list of employees with a salary less than the average refers to SELECT name FROM Employee WHERE salary < (SELECT AVG(salary) FROM Employee);