MothersonSumi INfotech & Designs Data Analyst Interview Questions and Answers

Q1. Questions on my previous work experience
Add your answer
Q2. SQL Questions based on random scenario
Add your answer

DURATION 1.3 HRS WITH REASONING AND 2 CODING QUESTION

Q1. SQL QUESTION FIND N TH HIGHEST SALARY
Ans. 
Use SQL query with ORDER BY and LIMIT to find the Nth highest salary.
• Use ORDER BY clause to sort salaries in descending order

• Use LIMIT to specify the Nth highest salary

• Example: SELECT salary FROM employees ORDER BY salary DESC LIMIT N,1
Answered by AI
Add your answer
Q2. SQL QUESTION PIVOT TABLE QUESTION
Add your answer

SQL and python questions are very easy.

Q1. Introduce yourself
Add your answer

Q1. What challenges have you encountered in addressing customer problems?
Add your answer
Q2. Product quality
Add your answer

Provided sales case study, asked to analyse the same ans provide insights

General knowledge

English knowledge

Q1. Self and technical
Add your answer