According to my research I found the following
The 247 references to wine and strong drink in the Bible can be divided into 3 broad categories: positive references, negative references, and neutral references. We will first summarize these categories and then examine them in detail.
Summary of references to wine in Scripture
On the negative side, there are 17 warnings against abusing alcohol, 19 examples of people abusing alcohol, 3 references to selecting leaders, and one verse advocating abstinence if drinking will cause a brother to stumble. Total negative references: 40, or 16%.
On the positive side, there are 59 references to the commonly accepted practice of drinking wine (and strong drink) with meals, 27 references to the abundance of wine as an example of God's blessing, 20 references to the loss of wine and strong drink as an example of God's curse, 25 references to the use of wine in offerings and sacrifices, 9 references to wine being used as a gift, and 5 metaphorical references to wine as a basis for a favorable comparison. Total positive references: 145, or 59%.
In what could be considered neutral references, there are 33 symbolic references ("the wine of His wrath," etc.), 21 references to vows of abstinence, 4 references to people falsely accused of being drunk, and 4 references which don't seem to fit a category. Total neutral references: 62, or 25%.