Nordstrom interview question

A complicated SQL coding challenge