Amazon Interview Question

Elaborate the most difficult project you have done before. SQL: Join definition, window functions