Capital One Interview Question

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