Database: college_2
Question: What are the names and salaries for instructors who earn less than the average salary of instructors in the Physics department?
SQL:
SELECT name ,  salary FROM instructor WHERE salary  <  (SELECT avg(salary) FROM instructor WHERE dept_name  =  'Physics')