sql in not in, window function
Intelligence Interview Questions
6,936 intelligence interview questions shared by candidates
ML concepts, Advanced SQL, Python
What is your top 3 technical skills? How would you rate your SQL skills out of 5?
First Interview (With the recruiter): - Ask to pass through my resume. - How I get requirements, with which frequency, and what I ask for. - Size of the data I'm used to work. - Estathistical knowledge I used and scripting language (Python, R) - How to use lead and lag function and aggregations functions. - A time when I worked with a business area, who are they, what was the problem, what was the solution, and which was the quantitative result. - A time when I had to dive deep to discover the root cause of a problem. Second Interview (SQL + Leadership Principles): - When I reached a goal, and exceed it. -When I delivered a project under a tight timeline. - When I got negative feedback and what I did with it - Three things that I do to improve my overall effectiveness. - Amazon wants to flag clients who bought Alexas and Books to send them campaigns to the next Kindle version. What I expected to find in terms of data (which tables and which fields). Then I had to use those tables and create a query to bring the client_id of those clients.
Q: What is a primary key? Q: What is the difference between HAVING and WHERE? Q: Can there be more than one primary key?
Easy SQL Leetcode questions Questions based on past experience related to Amazon LP.
when was a time you struggled with a customer. when was a time you went last mile for a customer.
Tell me about yourself and why do you want this job
Basic SQL syntax and Amazon 16 leadership related behavioral questions
Leadership Principles; see the other reviews, they're pretty accurate
Viewing 2111 - 2120 interview questions