Meta Interview Question

Window Functions and joins in sql