Amazon (Business Analyst) interview questions

I applied online and a sourcing coordinator reached out the next day asking for additional information like compensation expectation. I then was scheduled for a phone interview which I was advised to be behavioral-based. I then found out that the was also going to be a live coding exercise during the phone interview.

phone interview with hiring manager. The interviewer is really nice. I am expecting sql test since I was asked to open code share. But instead it is only some resume questions and a case study.