six I imagine that in very first question you've shared variable concerning outer query and subquery, so For each row in most important query, subquery executes but in 2nd one particular the subquery only executes just one time which way functionality enhanced. “But we need to start with some thing, and I do think Here is the appropriate area to