State Street Graduate Internship Program interview questions

First, we had an online assessment that contained two coding questions and some multiple-choice questions. A few days later, we had a PPT session where they announced the results of the online assessment, followed by the technical round. In the technical round, they asked me mainly about SQL queries (joins and subqueries). The interviewer also asked some basic DSA questions, such as the difference between an array and an ArrayList. He gave me a puzzle to test my logical thinking skills. He also asked about my projects. The technical interview lasted around 30 minutes. After that, I was selected for the HR interview, where she asked basic HR questions.