Question d’entretien chez Amazon

One more basic SQL query which uses subquery