First Citizens Bank interview question

Scd Sql coding Scenario based