Question d’entretien chez Pocket Gems

Given a test set of tables as an example, how do you implement the query in SQL