Pregunta de entrevista de Citibank

Questions regarding sql queries and joining tables