And Finally…
•
Transformed query:
•
•
Select
P.eid, P.sal
•
From
PartialResult P,
LimitedAvgSal V
•
Where
P.did=V.did
•
And
P.sal > V.avgsal