ZS Associates Interview Question

Describe SQL joins and query based on window function