Amazon business intelligence engineer (intern) interview questions

1 round with 2 people for each session. The first one is more technical. It asked SQL(definition and live coding) and several LP questions. The other one started with a case study and was followed by multiple LP questions. There will be many follow-up questions for the second one.

In my interview, I got hit with two SQL questions - one that wanted me to play around with UNION ALL, and the other was like a join operation problem. Then, we dived into graph interpretation. The interviewers were awesome, guiding me through it all.