Intuit Interview Question

Merge Historical and new data and perform upsert (SQL and Spark) Hive internals. Employee based SQL queries using window functions