The question includes example data. And the required result set. Unfortunately the result set cannot be obtained from the data.

It's clearly an error, and Steve will be along sooner or later to say as much.