Question d’entretien chez Wayfair

SQL question, basic joins from 2 table and ordering