President Donald Trump's executive order to ban transgender female athletes from competition delivered on a promise he made on the campaign trail.