You might be asking at this point,“Why go to all this trouble? Why not just do
the complex JOIN in the outer query and be done with it?”The reason is that
you’ll get the wrong answer! Actually, the rows returned will all be rows from
the Recipes table for seafood recipes, but you might get some rows more than
once. Let’s try to solve this without the subquery to see why you get duplicate
rows