SELECT name ,  salary FROM instructor WHERE salary  <  (SELECT avg(salary) FROM instructor WHERE dept_name  =  'Physics')
What are the names and salaries for instructors who earn less than the average salary of 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 )
What are the names and salaries for instructors who earn less than the average salary of instructors in the Physics department ?