Amazon Data Engineer interview questions

1 hour interview, including 2 part. 1. SQL testing: this includes window function and how to evaluate there is duplicate records in this table. 2. work experience: what is your project with biggest impact? and why is this project?

DE 1 level. Had to do a take home sql screening which took me like 2 hours to complete. Easy take home tbh, even the "hard" sql question is medium LC at best. Then had the "phone screen" with a DE2. He was rude and not helpful, he definitely didn't wanted to be there. I got asked 3 classic behavioral questions and then 3 easy to medium sql questions. No python. Not sure if they were only focusing on sql or that I took too long on sql (didn't really) and didn't have time for python questions.