SELECT name ,  salary FROM instructor WHERE salary  <  (SELECT avg(salary) FROM instructor WHERE dept_name  =  'Physics')
Find the name and salary of instructors whose salary is below the average salary of the instructors in the Physics department.
SELECT name , salary FROM instructor WHERE salary < ( SELECT avg ( salary ) FROM instructor WHERE dept_name = 'Physics ' )
select name , salary from instructor where salary < ( select avg ( salary ) from instructor where dept_name = value )
Find the name and salary of instructors whose salary is below the average salary of the instructors in the Physics department .