Question d’entretien chez Norfolk Southern

Answer a relatively complex sql query