Quantiphi interview question

SCD 1,2 and 3. SQL questions