Database: college_2
Question: Find the name and salary of instructors whose salary is below the average salary of the instructors in the Physics department.
SQL:
SELECT name ,  salary FROM instructor WHERE salary  <  (SELECT avg(salary) FROM instructor WHERE dept_name  =  'Physics')