Autodesk interview question

SQL Join questions, Questions on window functions