SQL Scoping Is Surprisingly Subtle and Semantic

The LIMIT clause should not be needed (tried with Oracle)

  select (select sum(1) from aa) from xx;
  3
  3
  3