Amazon interview question

SQL question on JOINS, Python question on Pandas manipulation