FIS interview question

SQL question, coding question