I had the initial phone interview.

The interviewer was easy to understand and provided a few hints. He listened to my answers and gave me time to solve each problem.

The interview started with introductions, then two follow-up questions from my resume regarding cost storage and optimization.

Next, there were two SQL questions, one hard and one medium. I was then given a Python question that was different from the usual Python questions I receive. (I was not able to solve this).

Another question followed, this time on SQL, to identify the output for various types of joins.

Finally, there was a question on Leadership Principles.

The interview took 90 minutes to complete.

3 SQL questions, out of which 2 were hard and 1 was medium. 1 Python question, which was medium+. 1 Leadership principle.

Python question:

You are given a CSV file with the following data:

std_name,physics,chemistry,maths Alice,85,90,95 Bob,75,80,70 Charlie,60,65,75

Write a Python code to calculate the average and sum of all subjects for each student.

Note: Do not use Python libraries. Solve the problem using DSA.