SELECT DISTINCT salary FROM instructor WHERE salary  <  (SELECT max(salary) FROM instructor)
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 )
select distinct salary from instructor where salary < ( select max ( salary ) from instructor )
What are the distinct salaries of all instructors who earned less than the maximum salary ?