Question d’entretien chez Smoothstack

Asked to come up with an SQL query given a few table attributes