Pregunta de entrevista de Commonwealth Bank of Australia

SQL - joins, functions, sub query