Question d’entretien chez Expedia Group

Write a SQL command based off of these query requirements.