Pergunta de entrevista da empresa Citizens

Complex SQL query. Be sure to review about different kinds of Joins and Aggregate functions.