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