Coforge interview question

sql window function pyspark window function dbt scd type1