Veracross Interview Question

Aggregate some data about a user in sql.