Database: college_2
Question: What are the distinct salaries of all instructors who earned less than the maximum salary?
SQL:
SELECT DISTINCT salary FROM instructor WHERE salary  <  (SELECT max(salary) FROM instructor)