Amazon interview question

SQL 1. question on Option clause