[SQL] Scalar subquery unnesting

- 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