abcd

4join14join2

4join14join2

2join32one

2join32one

1oneNULLNULL

NULLNULLNULLtwo

NULLNULLNULLthree

The reason I missed the answer is that I thought if you order by column d, "two" would be at the bottom. Doesn't "two" come after "three" in an order clause?

Well, I ignored the "desc" after the order by. Darn it. Details, details.