SDAD Technology Data Research Analyst Interview Questions and Answers

Q1. What is the output of a GROUP BY statement on a column with unique values?
Ans. 
A GROUP BY statement on unique values returns the same unique values, often used for aggregation.
• GROUP BY aggregates data based on specified columns.

• If the column has unique values, each group will contain only one row.

• Example: SELECT column_name, COUNT(*) FROM table GROUP BY column_name; returns unique values with their counts.

• Useful for summarizing data, but no meaningful aggregation occurs with unique values.
Answered by AI
Add your answer
Q2. What is the output regarding the number of rows in left, right, and inner joins?
Add your answer

Quant and Cat based questions

Q1. Puzzles and Sql
Add your answer

Q1. SQL related question asked like Window function, Rank, dense rank, Intermediate to hard level questions.
Add your answer

Q1. Difference between rank & dense rank
Ans. 
Rank assigns unique numbers to each row based on the order specified, while dense rank assigns consecutive numbers without gaps.
• Rank leaves gaps in the ranking sequence if there are ties, while dense rank does not

• Rank function is used to assign a unique rank to each row, while dense rank function is used to assign a unique rank to each distinct row

• For example, if there are two rows with the same value and rank 1, the n...read more
Answered by AI
Add your answer
Q2. Given two tables Tell how many values would be there for left right inner outer join
Ans. 
The number of values in different types of joins depends on the relationship between the tables.
• In a left join, all values from the left table are included along with matching values from the right table. The number of values will be equal to the number of rows in the left table.

• In a right join, all values from the right table are included along with matching values from the left table. The number of values will be equ...read more
Answered by AI
Add your answer
Q3. Find the newest customer id for every product
Ans. 
Use SQL query to find the newest customer id for every product
• Use GROUP BY clause to group by product

• Use MAX() function to find the newest customer id for each product

• Join the tables if necessary
Answered by AI
Add your answer

Q1. Sql questions checking basic concepts
Add your answer
Q2. Excel task based questions
Add your answer

3 SQL QUESTIONS, they were lengthy

Q1. Joins and window function
Add your answer
Q2. Guesstimates and different puzzles
Add your answer

Q1. Business case study
Add your answer