Wells Fargo Interview Question

Write a SQL query to pull records from given tables that uses a multiple CASE and aggregates, as specified.