Datametica Interview Question

On joins, Analytical functions and some question on python.