title: How do I subquery this in SQL Server 2008?
body: <p>Calculate the minimum salary for exempt employees and the average salary for non-exempt employees in a SINGLE SQL statement. Use subqueries to incorporate both elements in the query. It should look something like:</p>
  
  <pre><code>Min Exempt Salary   Average Non-Exempt Salary
  47,000                           35,271
  </code></pre>
  
  <p>I know how to do it separate but cannot figure how to do it as it stated above , this is the statments I have.</p>
  
  <pre><code>SELECT jobs1.exempt_nonexempt_status,
         Min (employees.salary)AS Minimal_Exempt_Salary
  FROM   employees
         LEFT JOIN jobs1
                ON employees.job_title = jobs1.job_title
  WHERE  jobs1.exempt_nonexempt_status = 'Exempt'
  GROUP  BY jobs1.exempt_nonexempt_status
  
  SELECT jobs1.exempt_nonexempt_status,
         Avg (employees.salary)AS Average_Non_Exempt_Salary
  FROM   employees
         LEFT JOIN jobs1
                ON employees.job_title = jobs1.job_title
  WHERE  jobs1.exempt_nonexempt_status = 'Non-exempt'
  GROUP  BY jobs1.exempt_nonexempt_status 
  </code></pre>