Prince Andrew is another whose attempts at finding a role have not exactly ended well. Even before the scandal involving sex assault claims, which he denied, he had gained the nickname of Air Miles Andy for his many overseas trips.