Consider the query:

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;

Rewrite this query without using the with construct.