Robi interview question

Database question about join and Aggregate functions.