ZS Associates interview question

Describe SQL joins and query based on window function