Infosys Specialist Programmer interview questions

It as through hackwithinfy 2025. People who could solve 2 out of 3 questions were in category 2 and people who could solve 3 out of 3 were in category 1. The question were medium to hard. Around 20 students selected for interview of sp and dse role. Got a month approx to prepare for interview. Had to solve 1 out of 2 questions in interview then asked basics of sql, some queries, project based questions. I was not able to solve the question in interview hence rejected.