Aptean interview question

SQL queries were unexpected to me.