Former Prince Andrew only got 4 percent approval