I just did 2nd round of amazon interview for data engineer position. They asked me leetcode hard SQL problem
262. Trips and Users. I was able to do this problem, waiting for the results

Also they asked me to create a data model for amazon for taking order and shipping the product.
they ask complex problem in my experience and how did I solve it