Sophie, Countess of Wessex, has become known as a hard-working royal with style—and a happy marriage with Edward