People Tech Group Data Analyst Interview Questions and Answers

Q1. Tableau interview questioins
Add your answer
Q2. SQl based quetions
Add your answer

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.

Quantitative aptitude test.

Q1. Introduce yourself
Add your answer

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