Amazon Program Manager interview questions

After the exploratory rounds, there were 4 rounds scheduled. Ppl who took interview were less experienced. They didn't even gone through the resume. Asked situation based questions. I never expected from Amazon such interview process.

2nd round of interview: I received an email from the HR coordinator the afternoon before the interview saying that it will be a "Basic Excel Competency Test". Even with less than 24 hours notice I was able to refresh my knowledge of excel since it was not difficult. However in the actual competency test they asked about SQL queries. I was not given any forewarning about the content of the technical assessment regarding SQL and since i had not used it in a very long time in my current job, and did not know to prepare for it, I failed it.