Converting Nested Queries
Select distinct x.name, x.maker
From product x
Where x.color= “blue”
AND x.price < SOME (Select y.price
From product y
Where x.maker = y.maker
AND
y.color=“blue”)
Let’s compute the complement first: