Shell Associate Data Engineer interview questions

It was a technical interview for 1.5 hours. They asked everything starting from DSA, SQL and then HR questions in the end. There were 2 interviewers and alternatively they used to ask questions. Asked me to write a sql query

The interview process was very smooth. Well structured, interviewers were knowledgeable and knew what they wanted to assess about the candidate. They focus on all the projects and skills mentioned on the resume of the candidate. They also focus on how the candidate behaves and conduct themselves during the interview.