TOPS Technologies Data Analyst Interview Questions and Answers

Q1. SQL question difference between having and where
Ans. 
HAVING is used with GROUP BY to filter groups, WHERE is used to filter rows
• HAVING is used with GROUP BY to filter groups based on aggregate functions

• WHERE is used to filter rows based on conditions

• HAVING is applied after GROUP BY, WHERE is applied before GROUP BY

• Example: SELECT department, AVG(salary) FROM employees GROUP BY department HAVING AVG(salary) > 50000;

• Example: SELECT * FROM employees WHERE department = 'S
Answered by AI
Add your answer

Sql, numpy, pandas, dictionary, pandas group by, merging

Q1. Normal questions
Add your answer

Q1. SQL queries , python pandas and numpy , power bi related questions
Add your answer

Q1. Previous experience, skills and expertise
Add your answer

Test was of 1.5 hrs and it was online. It was completely based on technical questions.

This test was offline and it was a pen paper test wherein 10 questions will be given you have to write code or spot the error and correct them.

Q1. Asked questions about React
Add your answer
Q2. Question based on project
Add your answer

Data structure and algorithm, easy and medium questions

It was quite easy

Q1. Based on resume. Go through with your resume..
Add your answer

Basic coding maths aptitude java python communication skills test

Java coding c plus python SQL oracle dbmsos

Aptitude on clocks, calenders, boats and streams..

Aptitude based on clocks, calendars, boats and streams..

Q1. Asked about python, c, c++, html, css
Add your answer
Q2. Python basics, differences between them
Add your answer