Amazon Analyst Interview Questions and Answers for Experienced

Python, SQL, Quant, Statistics, Numpy

Q1. SQL, Python, Puzzle total 9Q
Add your answer
Q2. Table, Query, 2 puzzle, Python 1 code (4 Sub code)
Add your answer

Q1. Yet to declare result for the round 2 i feel +ve for round 2 result lets se
Add your answer

SQL and Excel questions

Q1. Finance and analysis related questions
Add your answer

SQL and Python Questions

Q1. SQL and case study question
Add your answer

Q1. Questions mostly focused on window functions like row_number and aggregate functions like group by there was also a question based on self-join.
Add your answer

Q1. Difference Between Rank and Dense Rank
Ans. 
Rank assigns unique ranks to each distinct value, while Dense Rank assigns consecutive ranks to each distinct value.
• Rank does not skip ranks when there are ties, while Dense Rank does

• Rank will have gaps in ranks if there are ties, while Dense Rank will not

• Rank function is used to assign a unique rank to each distinct row, while Dense Rank function is used to assign consecutive ranks to each distinct row
Answered by AI
Add your answer
Q2. Some Basic Joins
Add your answer
Q3. Socks Pair Puzzle Qustions
Add your answer