SQL Scoping Is Surprisingly Subtle and Semantic

The LIMIT clause should not be needed (tried with Oracle)<p><pre><code> select (select sum(1) from aa) from xx; 3 3 3</code></pre>