Consider the query: Rewrite this query without using the with construct. with dept_total (dept_name, value) as (select

Consider the query:

Rewrite this query without using the with construct.

Transcribed Image Text:

with dept_total (dept_name, value) as (select dept_name, sum(salary) from instructor group by dept_name), dept_total_avg(value) as (select avg(value) from dept_total) select dept_name from dept_total, dept_total_avg where dept_total.value >= dept_total_avg.value;