Robi Interview Question

Database question about join and Aggregate functions.