Infosys Interview Question

SCD 2 and write a query to check that