Amazon Business Analyst I interview questions

The phone interview went really well in which the interviewer asked one Amazon leadership question, some follow-up questions, and then 4 SQL Queries. The final interview was rescheduled one hour before which was disappointing and the interviewer asked more than 15 questions (it was exhausting in a one-hour phone call with more than 15 questions and also shuffled sometimes technical and then again Amazon leadership it should have done in sequence), including Amazon leadership, tableau, questions like if sales churn is 5% what can be the cause and similar product-related questions. For the Amazon leadership question, I answered one question that was not related to business analysis but it was relevant to the question like how you handled difficult customers so the interviewer asked me to give another example that relates to BA but as I had worked previously as an IT analyst were I had to handle difficult customer I gave that example using STAR method but she didn't accept that answer so basically Amazon just expect you to create a story using STAR method no matter if you have actually worked on that just give position related examples then you are good or they reject you, I didn't like this concept. Similarly in the last round of the interview, the person who was shadowing even he asked some questions which I answered correctly but HR had given a heads-up that I would see another person too but they would not ask any questions they were only for shadowing then why that person even asked the question. It was very confusing one time the other person asked me to write SQL queries and before completing the other interview/shadowing asked about Amazon leadership, they should have first let me finish the SQL part, also the leadership question was already covered in the first half of the call but again they asked when I was working on SQL. I worked really hard for this interview for almost a month so even the company should value the candidate's time and should have a systematic approach to the interview process, and question sequence. Also in 20 minutes how can you write 6 Medium-level SQL queries in that too again asked leadership-related questions finally at the end time was already over and I could solve only 4 SQL queries. I regret for giving so much time for this interview.