Anonymous Interview Question

based on join , aggregate function and windows function