Amazon Interview Question

SQL question on simple join