Databricks interview question

SQL questions involving window function