Question d’entretien chez Wells Fargo

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