Converting Nested Queries
•(Select
x.name, x.maker
From product x
Where x.color = “blue”)
•
EXCEPT
•
(Select x.name, x.maker
• From
product x, product y
Where x.color= “blue” AND x.maker = y.maker
•
AND y.color=“blue” AND x.price
< y.price)