Amazon Interview Question

data warehousing, data modeling related questions. Joins, union, self join, window functions