What sugar does to your body

Just how bad for you is eating sugar? And why is fruit still a good option - even though it has lots of sugar? Source