What are the distinct salaries of all instructors who earned less than the maximum salary?
SELECT DISTINCT salary FROM instructor WHERE salary  <  (SELECT max(salary) FROM instructor)
distinct salaries = SELECT DISTINCT salary; less than the maximum salary = salary < (SELECT MAX(salary) FROM instructor);