Historically, is there any case in which prohibition of alcohol has actually dissuaded its consumption?
It failed miserably in the United States, for example...
Prohibition was an Era in American history from 1920-1933 - and - it failed miserably. If anything, it made alcohol more popular.
Prohibition, in general, also means to prohibit something via law or religion though. The religious aspect is the only case that one can see prohibition working. ::Insert Mormonism/Islamic religion/et cetera here::
No In Gujarat , A state of India There is prohibition since 1958 which has never worked and also created lots of illegal troubles as well as loss of taxes on booze.
Bombay State had prohibition between 1948 and 1950, and again from 1958. Gujarat has a sumptuary law in force that proscribes the manufacture, storage, sale and consumption of alcoholic beverages. The legislation has been in force since 1 May 1960 when Bombay State was bifurcated into the states of Maharashtra and Gujarat. The Bombay Prohibition Act, 1949 is still in force in Gujarat state, however there is licensing regime in Maharashtra with granting licenses to vendors and traders.
Gujarat is the only Indian state with a death penalty for the manufacture and sale of homemade liquor that results in fatalities. The legislation is titled the Bombay Prohibition (Gujarat Amendment) Bill, 2009. The legislation was prompted by numerous deaths resulting from the consumption of methyl alcohol.
But the result is that people dies due to homemade liqueurs every month and every year. You can check this: Gujarat alcohol poisonings.
As with almost anything that becomes banned or illegal it causes the substance to increase in cost greatly since the acquisition of the substance requires illegal acts from manufacturing to distribution. Therefore, no prohibition does not generally work in stopping consumption but it does result in many other legal issues.
In a world where people follow laws and do not attempt to profit from illegal activities, Prohibition of a product would 'in theory' work. However, that is not the reality we live in.
Historical evidence shows us that with a vast majority of prohibition of a product, the demand for said product does not immediately drop, but the supply does. This makes the product very profitable for those entities that are able to obtain said product and then distribute it for basically any price they so choose.
Thus for the example with alcohol prohibition in the 1920's US, crime families immediately started to acquire or make product, distribute it, and even open facilities to sell and consume. This took out all middle men and gave them full and complete control of the entire supply chain, and thus allowed for them to keep maximum profits.
Another example in the US, is how the war on drugs has done little to stop the demand for drug in the country and only made the cartels more money.