PwC interview question

SCD, DWH Concepts, SQL concepts, Previous project relaed