Pregunta de entrevista de Zillow

SQL/Python exercises, and data-preprocessing question