Amazon interview question

SQL question: using where clause