Amazon Business Analyst interview questions

Initially, I had this Excel exam. After a few days, I got an email that I passed it. Then we proceed to the initial interview. The interview went well. It focused more on my previous work experience and the reports I accomplished.

Got an e-mail from HR about 1st Phone Screen Interview and I was asked to prepare for "What would you do when,...." kind of situations and SQL. They changed my interviewer thrice and then my interview just consisted of easy-medium level SQL theory and coding. There were no behavioral questions/introduction/anything from my resume as it was only my first round. I answered every single SQL question correctly and received a reject next day. They never asked me for my feedback. What kind of sorcery is this?