Bank of America interview question

SQL question/R or Python coding in data analysis