Pergunta de entrevista da empresa Commonwealth Bank of Australia

SQL - joins, functions, sub query