JOIN or SUBQUERY Question

SQL++
4

Thanks Cihan understood it really helps as now I can focus on the Data Modelling
The relation ship is 1:M between Challenge and a ChallengeUser that is 1 Challenge can have many Challenge Users.