Query join with sub query

Noncompliant Code Example

Compliant Solution

See