Comcast interview question

Joins, SCD types, windows function☆☆