Zillow interview question

sql, case study, what would you do if x metric dropped