Pregunta de entrevista de Amazon

SQL question on JOINS, Python question on Pandas manipulation