Converting Nested Queries
Select
distinct 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
This one becomes a SFW query:
This returns exactly the products we DON’T want, so…