Yum! Data Scientist Interview Questions and Answers

1 dsa question 2 sql queries questions on data analysis

Q1. Sql query using window function
Ans. 
Using window functions in SQL to perform calculations within a specific subset of data.
• Window functions are used to perform calculations across a set of rows related to the current row.

• Common window functions include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE().

• Example: SELECT employee_id, salary, AVG(salary) OVER (PARTITION BY department_id) AS avg_salary FROM employees;
Answered by AI
Add your answer
Q2. Dsa question of string manipulation
Add your answer

Q1. Sql query advanced level
Add your answer
Q2. Guesstimate and resume questions
Add your answer

Q1. Basic common HR questions
Add your answer
Q2. Questions about educational background cultural fit
Add your answer

Simple DSA along with data science topics

Q1. Mostly on advance data science topics
Add your answer

Q1. It was mostly interactive
Add your answer