[Amazon Onsite Interview] Failed to understand the problem for one coding Interview

Hi People,

I finished onsite interview with Amazon. Wonder anyone got similar experience ? What are the chances to get an offer?

The coding problems i got were leetcode medium level questions.
First coding interview, did poorly. didn't figure out what the interviewer wanted after 20mins.
2nd coding interview, did great. I gave optimal solution for a graph topology sort problem with required values derived along the sorted path.
3rd coding interview, a tricky dp problem, did ok. Solved in time, and fixed a bug along the way.
i have one additional one-hour LP interview from the hiring manager. All BQ answered properly.
For the system design interview, did relatively ok but not fantastic. Designed the architecture, explained scalibility, reliability, caching, db considerations, but didnt gave a good answer for a question related to efficient data retrieval from database.