Wells Fargo interview question

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