4. Display Department_id, Job_id, the Average salary for this combination

under alias Average Dept/Job Pay and the Lowest salary for this combination as well under alias Lowest Dept/Job Pay, but only if that Lowest Pay falls in the range $5000 - $15000.

Exclude Vice Presidents from this query and departments IT and SALES as well.

Sort the output according to the Department_id and then by Job_id.

You need to use only the Subquery method (NO joins allowed).