Question d’entretien chez Google

Write an SQL query for this particular question ?