Amazon interview question

One more basic SQL query which uses subquery