•Select E.eid, E.sal
•From Emp E, Dept D, DepAvgSal V
•Where E.did=D.did AND D.did=V.did
• And
E.age < 30 and D.budget > 100k
• And
E.sal > V.avgsal
•DepAvgsal
needs to be evaluated only for departments where V.did IN
• Select E.did
• From Emp E, Dept D
• Where E.did=D.did
• And
E.age < 30 and D.budget >
100K