Pergunta de entrevista da empresa Ameriprise

Basic SQL Question like using window functions, and finding syntax errors in a SQL code. Then they ask me to live code python simple question;