Pergunta de entrevista da empresa Palmer Consulting Group

SQL question about selecting and joins