Same Query with a Subquery in place of a join

This is the same query as our first query but it uses a Sub query instead of a Join

Notice the Sub Query is being run on a different table than the main query