Nordstrom Interview Question

A complicated SQL coding challenge