Meta interview question

Window Functions and joins in sql