Pregunta de entrevista de Zillow

How would you order the following data suing MySQL?