Implement scalar sub-query in SELECT clause.