Amazon interview question

4 SQL query questions with the sample tables