[SQL] Scalar subquery unnesting

[iannamkr]

• https://jack-of-all-trades.tistory.com/244
• https://asktom.oracle.com/pls/apex/asktom.search?tag=scalar-subquery-unnesting
• https://stackoverflow.com/a/27854382/11128647