Frage im Vorstellungsgespräch bei 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;