New posts in Correlated Subquery

Using a single SQL correlated sub-query to get two columns