The outer PROC SQL query retrieves data from the view descriptor ... the subquery must return a single value. In this example, the AVG summary function returns the average salary of employees in the ...