Datametica interview question

On joins, Analytical functions and some question on python.