Capital One interview question

well prepared for the scenario based questions and good knowledge about SQL