i360 interview question

SQL - Window functions, Explain output of the following code, Nulls, joins on Nulls. Python - Arrays, Indexes