The new research shows the risk of cancer was significantly higher for some drinks