Amazon Interview Question

About Sql query on Join