Zillow interview question

SQL/Python exercises, and data-preprocessing question