Veracross interview question

Aggregate some data about a user in sql.